{"text_format":"1","workbook":"xlsx","n_sheets":74,"sheets":["Tables","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39","40","41","42","43","44","45","46","47","48","49","50","51","52","53","54","55","56","57","58","59","60","61","62","63","64","65","66","67","68","69","70","71","72","73"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":69,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Tables","index":0,"n_rows":81,"n_cols":1,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
["Tables"]
["Table 1: SEBI Registered Market Intermediaries/Institutions"]
["Table 2: Company-Wise Capital Raised through Public and Rights Issues (Equity) during July-2017"]
["Table 3: Open Offers under SEBI Takeover Code closed during July-2017"]
["Table 4: Substantial Acquisition of Shares and Takeovers"]
["Table 5: Capital Raised from the Primary Market through though Public and Rights Issues "]
["Table 6: Issues Listed on SME Platform"]
["Table 7: Industry-wise Classification of Capital Raised through Public and Rights Issues "]
["Table 8: Sector-wise and Region-wise Distribution of Capital Mobilised through Public and Rights Issues "]
["Table 9: Size-wise Classification of Capital Raised through Public and Rights Issues "]
["Table 10: Capital Raised by Listed Companies from the Primary Market through QIPs"]
["Table 11: Preferential Allotments Listed at BSE and NSE"]
["Table 12: Private Placement of Corporate Debt Reported to BSE and NSE"]
["Table 13: Trading in the Corporate Debt Market"]
["Table 14: Ratings Assigned for Long-term Corporate Debt Securities (Maturity ≥ 1 year)"]
["Table 15: Review of Accepted Ratings of Corporate Debt Securities (Maturity ≥ 1 year)"]
["Table 16: Distribution of Turnover on Cash Segments of Exchanges (₹ crore)"]
["Table 17: Trends in Cash Segment of BSE "]
["Table 18: Trends in Cash Segment of NSE "]
["Table 19: City-wise Distribution of Turnover on Cash Segments of BSE and NSE"]
["Table 20: Category-wise Share of Turnover in Cash Segment of BSE"]
["Table 21: Category-wise Share of Turnover in Cash Segment of NSE"]
["Table 22: Component Stocks: S&P BSE Sensex during July-2017"]
["Table 23: Component Stocks: Nifty 50 Index during July-2017"]
["Table 24: Advances/Declines in Cash Segment of BSE and NSE"]
["Table 25: Trading Frequency in Cash Segment of BSE and NSE"]
["Table 26: Daily Volatility of Major Indices  (percent)"]
["Table 27: Percentage Share of Top ‘N’ Securities/Members in Turnover of Cash Segment  (percent)"]
["Table 28: Settlement Statistics for Cash Segment of BSE "]
["Table 29: Settlement Statistics for Cash Segment of NSE "]
["Table 30: Trends in Equity Derivatives Segment at BSE (Turnover in Notional Value) "]
["Table 31: Trends in Equity Derivatives Segment at NSE "]
["Table 32: Settlement Statistics in Equity Derivatives Segment at BSE and NSE (₹ crore)"]
["Table 33: Category-wise Share of Turnover & Open Interest in Equity Derivative Segment of BSE"]
["Table 34: Category-wise Share of Turnover & Open Interest in Equity Derivative Segment of NSE"]
["Table 35: Instrument-wise Turnover in Index Derivatives at BSE"]
["Table 36: Instrument-wise Turnover in Index Derivatives at NSE"]
["Table 37: Trends in Currency Derivatives Segment at NSE"]
["Table 38: Trends in Currency Derivatives Segment at MSEI"]
["Table 39: Trends in Currency Derivatives Segment at BSE"]
["Table 40: Settlement Statistics of Currency Derivatives Segment (₹ crore)"]
["Table 41: Instrument-wise Turnover in Currency Derivatives of NSE"]
["Table 42: Instrument-wise Turnover in Currency Derivative Segment of MSEI"]
["Table 43: Instrument-wise Turnover in Currency Derivative Segment of BSE"]
["Table 44: Maturity-wise Turnover in Currency Derivative Segment of NSE  (₹ crore)"]
["Table 45: Maturity-wise Turnover in Currency Derivative Segment of MSEI (₹ crore)"]
["Table 46: Maturity-wise Turnover in Currency Derivative Segment of BSE (₹ crore)"]
["Table 47: Trading Statistics of Interest Rate Futures at BSE, NSE and MSEI"]
["Table 48: Settlement Statistics in Interest Rate Futures at BSE, NSE and MSEI (₹ crore)"]
["Table 49: Trends in Foreign Portfolio Investment"]
["Table 50: Notional Value of Offshore Derivative Instruments (ODIs) Vs Assets Under Custody (AUC) of FPIs/Deemed FPIs (₹ crore)"]
["Table 51: Assets under the Custody of Custodians"]
["Table 52: Trends in Resource Mobilization by Mutual Funds (₹ crore)"]
["Table 53: Type-wise Resource Mobilisation by Mutual Funds: Open-ended and Close-ended (₹ crore)"]
["Table 54: Scheme-wise Resource Mobilisation and Assets under Management by Mutual Funds (₹ crore)"]
["Table 55: Number of Schemes and Folios by Investment Objective           "]
["Table 56: Trends in Transactions on Stock Exchanges by Mutual Funds (₹ crore)"]
["Table 57: Asset Under Management by Portfolio Manager"]
["Table 58: Progress Report of NSDL & CDSl as on end of July-2017 (Listed Companies)"]
["Table 59: Progress of Dematerialisation at NSDL and CDSL (Listed and Unlisted Companies)"]
["Table 60: Depository Statistics for July-2017"]
["Table 61: Commoditiy Exchanges - Number of Permitted Commodities for trading"]
["Table 62: Trends in MCXCOMDEX of MCX and Dhaanya of NCDEX"]
["Table 63: Trends in Commodity Futures at MCX "]
["Table 64: Trends in Commodity Futures at NCDEX "]
["Table 65: Trends in Commodity Futures at NMCE "]
["Table 66: Category-wise Share in Turnover at MCX and NCDEX (percent) "]
["Table 67: Category-wise Percentage Share of Turnover & Open Interest at MCX"]
["Table 68: Category-wise  Percentage Share of Turnover & Open Interest at NCDEX"]
["Table 69: Category-wise Percentage Share of Turnover & Open Interest at NMCE"]
["Table 70: Commodity-wise Trends at MCX"]
["Table 71: Commodity-wise Trends at NCDEX"]
["Table 72: Commodity-wise Trends at NMCE"]
["Table 73: Macro Economic Indicators"]
[]
["N.B.: "]
["1. Na = Not Applicable"]
["2. NA: Not Available"]
["3. 1 crore = 10 million = 100 lakh."]
["4. The total provided in the Annexure and Statistical Tables may not always match with the sum total of the break-ups due to decimal differences. "]
["5. The data for the current month is provisional."]

{"sheet":"1","index":1,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Table 1: SEBI Registered Market Intermediaries/Institutions"]
["Market Intermediaries ","2016-17","2017-18$"]
["Stock Exchanges (Cash Market)",5,5]
["Stock Exchanges (Equity Derivatives Market)",3,3]
["Stock Exchanges (Currency Derivatives Market)",3,3]
["Stock Exchanges (Commodity Derivatives Market)",10,9]
["Brokers (Cash Segment)*",3192,3190]
["Corporate Brokers (Cash Segment)*",2775,2774]
["Brokers (Equity Derivatives Market) ",2651,2638]
["Brokers (Currency Derivatives Market)",1985,1985]
["Brokers (Debt Segment)",6,6]
["Brokers (Commodity Derivatives Market)",1162,1179]
["Sub-brokers (Cash Segment)*",30610,26853]
["Foreign Portfolio Investors (FPIs)",7807,8348]
["Deemed FPIs",974,418]
["Custodians",19,19]
["Depositories",2,2]
["Depository Participants-NSDL                                 ",276,279]
["Depository Participants-CDSL",588,588]
["Merchant Bankers",189,186]
["Bankers to an Issue",64,64]
["Underwriters",2,2]
["Debenture Trustees",32,32]
["Credit Rating Agencies",7,7]
["KYC Registration Agency (KRA)",5,5]
["Registrars to an Issue & Share Transfer Agents",73,73]
["Venture Capital Funds",198,196]
["Foreign Venture Capital Investors",218,217]
["Alternative Investment Funds",303,334]
["Portfolio Managers",218,232]
["Mutual Funds",45,45]
["Investment Advisors",577,677]
["Research Analysts",351,401]
["Infrastructure Investment Trusts (InVIT)",6,6]
["Collective Investment Management Company",1,1]
["Approved Intermediaries (Stock Lending Schemes) ",2,2]
["STP (Centralised Hub)",1,1]
["STP Service Providers",2,2]
["Notes: "]
["1. *Stock brokers/sub-brokers pertaining to active stock exchanges."]
["$ indicates as on June 30, 2017"]
["Source: SEBI, NSDL."]
["NA - Data not available"]

{"sheet":"2","index":2,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Table 2: Company-Wise Capital Raised through Public and Rights Issues (Equity) during July-2017"]
["S.No.","Name of the Issuer/\nCompany","Date of\n Opening","Type of \nIssue","Type of \nInstrument","No. of Shares\nIssued ","Face Value\n (`)","Premium Value    \n (`)","Issue Price (`)","Size of Issue \n (₹ crore)"]
[1,"Riddhi Corporate Services Ltd","2017-06-12","IPO (SME)","Equity Shares",950000,10,120,130,12.35]
[2,"Globe Textiles (India) Ltd","2017-06-12","IPO (SME)","Equity Shares",2688000,10,41,51,13.7088]
[3,"Tejas Networks Ltd","2017-06-14","IPO","Equity Shares",30221332,10,247,257,776.68823239999995]
[4,"ERIS Lifesciences Ltd","2017-06-16","IPO","Equity Shares",28875000,1,602,603,1741.1624999999999]
[5,"Central Depository Services (India) Ltd","2017-06-19","IPO","Equity Shares",35167208,10,139,149,523.99139920000005]
[6,"GTPL Hathway Ltd","2017-06-21","IPO","Equity Shares",28517650,10,160,170,484.80005]
[7,"Accord Synergy Ltd","2017-06-22","IPO (SME)","Equity Shares",972000,10,50,60,5.8319999999999999]
[8,"Pushpanjali Realms & Infratech Ltd","2017-06-27","IPO (SME)","Equity Shares",2646000,10,45,55,14.553000000000001]
[9,"AU Small Finance Bank Ltd","2017-06-28","IPO","Equity Shares",53422169,10,348,358,1912.5136502]
[10,"Ace Integrated Solutions Ltd","2017-06-29","IPO (SME)","Equity Shares",1800000,10,30,40,7.2]
[11,"Gautam Exim Ltd","2017-06-29","IPO (SME)","Equity Shares",831000,10,30,40,3.3239999999999998]
[12,"G G Engineering Ltd","2017-06-30","IPO (SME)","Equity Shares",1116000,10,10,20,2.2320000000000002]
[13,"Transwind Infrastructures Ltd","2017-06-30","IPO (SME)","Equity Shares",2700000,10,17,27,7.29]
[14,"Bansal Multiflex Ltd","2017-06-30","IPO (SME)","Equity Shares",2000000,10,21,31,6.2]
[15,"Zenotech Laboratories Ltd","2017-06-30","Rights ","Equity Shares",26603068,10,35,45,119.71380600000001]
[]
["Note: 1. All the issues are compiled from the Prospectus’ of Issuer Companies filed with SEBI."]
["Source: SEBI."]

{"sheet":"3","index":3,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,0,12,7],[0,0,0,7],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,1,6],[1,7,2,7]]}
["Table 3: Open Offers under SEBI Takeover Code closed during July-2017"]
["S.No.","Target Company","Acquirer","Offer Opening \nDate","Offer \nClosing Date","Offer Size ",null,"Offer\n Price \n(`) per share"]
[null,null,null,null,null,"No. of \nShares","Percent of Equity \nCapital"]
[1,"DEEPTI ALLOY STEEL LTD.","PARIKSHIT MAHATMA AND SANGITA JAIN","2017-05-19","2017-06-01",1001104,26,10]
[2,"MODIPON LTD.","MODI INTERCONTINENTAL PVT LTD","2017-05-24","2017-06-06",2895330,25.01,10]
[3,"RAJKAMAL SYNTHETICS LTD.","ANKUR AJMERA AND OTHERS","2017-05-24","2017-06-06",1690000,26,10.45]
[4,"SONA KOYO STEERING SYSTEMS LTD.","JTEKT CORPORATION","2017-05-30","2017-06-12",51672877,26,84]
[5,"VORA CONSTRUCTIONS LTD","SURESHBABU MALGE","2017-06-01","2017-06-14",1676839,26,50]
[6,"THE ANANDANAM RUBBER COMPANY LTD","BALAXI OVERSEAS PVT LTD","2017-06-05","2017-06-16",790400,26,15]
[7,"RCL RETAIL LTD","SHRIPAL SANGHVI AND OTHERS","2017-06-16","2017-06-30",3200600,26,10]
[8,"GOKALDAS EXPORTS LTD","CLEAR WEALTH CONSULTANCY SERVICES LLP","2017-06-16","2017-06-30",9179993,26,63.25]
[]
["Source: SEBI."]

{"sheet":"4","index":4,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,0,11,5],[12,0,12,8],[0,0,0,8],[1,0,4,0],[1,1,1,8],[2,1,2,6],[2,7,2,8],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,4,7],[3,8,4,8]]}
["Table 4: Substantial Acquisition of Shares and Takeovers"]
["Year/Month","Open Offers"]
[null,"Objectives",null,null,null,null,null,"Total"]
[null,"Change in Control \nof Management",null,"Consolidation of\n Holdings",null,"Substantial \nAcquisition",null,"No. of offers","Amount (₹ crore)"]
[null,"No. of offers","Amount (₹ crore)","No. of offers","Amount (₹ crore)","No. of offers","Amount (₹ crore)"]
["2016-17",42,5338.1431000000002,4,78.297700000000006,3,365.63040000000001,49,5782.0712000000012]
["2017-18$",18,1097.6500000000001,1,2.9,1,2.2400000000000002,20,1102.7899999999997]
["2017-04-01",9,586.92999999999995,0,0,0,0,9,586.92999999999995]
["2017-05-01",4,438.1,1,2.9,0,0,5,441]
["2017-06-01",5,72.62,0,0,1,2.2400000000000002,6,74.86]
[]
["$ indicates as on June 30, 2017"]
["Source: SEBI."]

{"sheet":"5","index":5,"n_rows":16,"n_cols":19,"rows_kept":16,"cut":false,"hidden":false,"merged":[[12,0,12,14],[13,0,13,14],[14,0,14,5],[2,11,2,14],[2,15,3,16],[2,17,3,18],[3,11,3,12],[3,13,3,14],[11,0,11,18],[0,0,0,17],[1,0,4,0],[1,1,3,2],[1,3,1,6],[1,7,1,10],[1,11,1,18],[2,3,3,4],[2,5,3,6],[2,7,3,8],[2,9,3,10]]}
["Table 5: Capital Raised from the Primary Market through though Public and Rights Issues "]
["Year/ Month","Total",null," Category-wise",null,null,null,"Issue-type",null,null,null,"Instrument-wise"]
[null,null,null,"Public ",null,"Rights",null,"      Listed",null,"IPOs",null,"Equities",null,null,null,"   CCPS/FCDs*",null,"Debt"]
[null,null,null,null,null,null,null,null,null,null,null,"At Par",null,"At Premium"]
[null,"No. of issues","Amount (₹ crore)","No. of issues","Amount (₹ crore)","No. of issues","Amount (₹ crore)","No. of issues","Amount (₹ crore)","No. of issues","Amount (₹ crore)","No. of issues","Amount (₹ crore)","No. of issues","Amount (₹ crore)","No. of issues","Amount (₹ crore)","No. of issues","Amount (₹ crore)"]
["2016-17",133,61848.23,121,58432.850000000006,12,3415.38,28,32753.130000000005,105,29095.230000000003,1,2.6,117,32517.989999999998,0,0,15,29327.64]
["2017-18$",34,10312.01,31,9824.4599999999991,3,487.54999999999995,4,2456.27,30,7855.74,0,0,33,8343.2900000000009,0,0,1,1968.72]
["2017-04-30",12,3200.37,10,2832.5299999999997,2,367.84,3,2336.56,9,863.81,0,0,11,1231.6500000000001,0,0,1,1968.72]
["2017-05-31",7,1480.08,7,1480.08,0,0,0,0,7,1480.08,0,0,7,1480.08,0,0,0,0]
["2017-06-30",15,5631.56,14,5511.85,1,119.71,1,119.71,14,5511.85,0,0,15,5631.56,0,0,0,0]
[]
["Notes: 1. The total provides category-wise total of any of the three sub-categories viz. public plus rights or issuer-type(listed plus IPOs) or instrument-wise(equities plus CCPS/FCDs plus debt). 2. Amount for public debt issue for last two months is provisional and may get updated 3. All the Issues are compiled from the Prospectus’ of Issuer Companies filed with SEBI. 4. * CCPS: Compulsory Convertible Preference Shares, FCDs: Fully Convertible Debentures."]
["5. Equity public issues also includes issues listed on SME platform."]
["6. The figures of public debt issue have been taken as per the closing dates of the issues."]
["$ indicates as on June 30, 2017"]
["Source: SEBI."]

{"sheet":"6","index":6,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,3,0],[1,1,2,2],[11,0,11,2],[12,0,12,3]]}
["Table 6: Issues Listed on SME Platform"]
["Year/ Month","Total"]
[]
[null,"No. of issue","Amount               (₹ crore)"]
["2016-17",79,1105.2845000000002]
["2017-18$",22,251.9984]
["2017-04-30",8,135.26060000000001]
["2017-05-31",5,44.048000000000002]
["2017-06-30",9,72.689800000000005]
[]
["$ indicates as on June 30, 2017"]
["Source: SEBI"]

{"sheet":"7","index":7,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,2,0],[1,1,1,2],[1,3,1,4]]}
["Table 7: Industry-wise Classification of Capital Raised through Public and Rights Issues "]
["Industry","2017-18$",null,"2017-07-01"]
[null,"No. of issues","Amount (₹ crore)","No. of issues","Amount (₹ crore)"]
["Airlines",0,0,0,0]
["Automobile",0,0,0,0]
["Banking and Finance",1,1968.72,0,0]
["Cement & Construction",3,526.22,1,14.55]
["Chemical",2,19.580000000000002,0,0]
["Consumer Services",0,0,0,0]
["Electrical Equipment/ Production",0,0,0,0]
["Engineering",2,13.12,2,13.12]
["Electronics",0,0,0,0]
["Entertainment",1,484.8,1,484.8]
["Financial Services",3,3660.85,2,2436.5]
["Food Processing",0,0,0,0]
["Healthcare and pharma",3,1922.07,2,1860.87]
["Hotels",0,0,0,0]
["Information Technology ",2,51.36,0,0]
["Misc.",13,142.41,5,31.3]
["Roads & Highways",0,0,0,0]
["Telecommunication",1,776.69,1,776.69]
["Textile",2,17.600000000000001,1,13.71]
["Plastic",0,0,0,0]
["Power",0,0,0,0]
["Printing",0,0,0,0]
["Oil & Natural Gas",1,728.56,0,0]
["Insurance",0,0,0,0]
["Total",34,10311.980000000001,15,5631.54]
[]
["$ indicates as on June 30, 2017"]
["Source: SEBI."]

{"sheet":"8","index":8,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,13,2,14],[0,0,0,14],[1,0,3,0],[1,1,2,2],[1,3,1,6],[1,7,1,14],[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,9,2,10],[2,11,2,12]]}
["Table 8: Sector-wise and Region-wise Distribution of Capital Mobilised through Public and Rights Issues "]
["Year/\nMonth"," Total",null,"Sector-wise",null,null,null,"Region-wise"]
[null,null,null," Private",null," Public",null," Northern",null," Eastern",null,"Western",null,"Southern"]
[null,"No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)"]
["2016-17",133,61848.23,117,31396.599999999995,16,30451.63,21,5480.04,8,1215.3400000000001,80,44374.51,24,10778.34]
["2017-18$",34,10312.01,32,7118.9400000000005,2,3193.0699999999997,9,3998.5600000000004,0,0,22,3448.32,3,2865.12]
["2017-04-30",12,3200.37,11,1231.6500000000001,1,1968.72,3,833.19,0,0,8,398.46,1,1968.72]
["2017-05-31",7,1480.08,6,255.73,1,1224.3499999999999,3,1247.1300000000001,0,0,4,232.94,0,0]
["2017-06-30",15,5631.56,15,5631.56,0,0,3,1918.24,0,0,10,2816.92,2,896.4]
[]
["$ indicates as on June 30, 2017"]
["Source: SEBI."]

{"sheet":"9","index":9,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,0,9,5],[10,0,10,4],[0,0,0,12],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,12]]}
["Table 9: Size-wise Classification of Capital Raised through Public and Rights Issues "]
["Year/\nMonth ","Total",null,"  < 5 crore",null,"≥ 5crore - < 10crore",null,"  ≥ 10 crore - < 50 crore",null,"  ≥ 50 crore - < 100 crore",null,"   ≥ 100 crore"]
[null,"No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)"]
["2016-17",133,61848.23,26,89.740000000000009,25,175.16,33,701.9799999999999,4,264.09000000000003,45,60617.26]
["2017-18$",34,10312.009999999998,6,18.95,8,50.4,7,124.14,2,126.35,11,9992.17]
["2017-04-30",12,3200.38,2,6.59,3,18.809999999999999,2,51.36,2,126.35,3,2997.27]
["2017-05-31",7,1480.07,2,6.8,1,5.07,2,32.17,0,0,2,1436.03]
["2017-06-30",15,5631.5599999999995,2,5.56,4,26.52,3,40.61,0,0,6,5558.87]
[]
["$ indicates as on June 30, 2017"]
["Source: SEBI."]

{"sheet":"10","index":10,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[10,0,10,5],[11,0,11,8],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[9,0,9,8]]}
["Table 10: Capital Raised by Listed Companies from the Primary Market through QIPs"]
["Year/           Month","Only BSE",null,"Only NSE",null,"Both NSE and BSE",null,"Total"]
[null,"No. of issues","Amount (₹ crore)","No. of issues","Amount (₹ crore)","No. of issues","Amount (₹ crore)","No. of issues","Amount (₹ crore)"]
["2016-17",0,0,0,0,20,8464.3492404999997,20,8464.3492404999997]
["2017-18$",0,0,0,0,8,27504.6868875,8,27504.6868875]
["2017-04-01",0,0,0,0,2,5206.6468875,2,5206.6468875]
["2017-05-01",0,0,0,0,5,7298.04,5,7298.04]
["2017-06-01",0,0,0,0,1,15000,1,15000]
[]
["Notes: 1. The above data includes both \"no. of issues\" and \"Amount\" raised on conversion of convertible securities issued on QIP basis. "]
["$ indicates as on June 30, 2017"]
["Source: BSE and NSE."]

{"sheet":"11","index":11,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,0,9,5],[10,0,10,8],[0,0,0,8],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8]]}
["Table 11: Preferential Allotments Listed at BSE and NSE"]
["Year/ Month","Only BSE",null,"Only NSE",null,"Both NSE and BSE",null,"Total"]
[null,"No. of  issues","Amount (₹ crore)","No. of  issues","Amount (₹ crore)","No. of  issues","Amount (₹ crore)","No. of  issues","Amount (₹ crore)"]
["2016-17",188,2957,17,1219,205,40073,410,44250]
["2017-18$",61,732.45,3,315.89699999999999,65,7988.4253699999999,129,9036.7723700000006]
["2017-04-01",18,426.95,0,0,23,1407.68,41,1834.63]
["2017-05-01",24,196.66,3,315.89699999999999,21,1864.3117999999999,48,2376.8688000000002]
["2017-06-01",19,108.84,0,0,21,4716.4335700000001,40,4825.2735700000003]
[]
["$ indicates as on June 30, 2017"]
["Source: BSE and NSE."]

{"sheet":"12","index":12,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,0,9,5],[10,0,10,8],[0,0,0,8],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8]]}
["Table 12: Private Placement of Corporate Debt Reported to BSE and NSE"]
["Year/ Month","Only BSE",null,"Only NSE",null,"Both NSE and BSE",null,"Total"]
[null,"No. of Issues","Amount (₹ crore)","No. of Issues","Amount (₹ crore)","No. of Issues","Amount (₹ crore)","No. of Issues","Amount (₹ crore)"]
["2016-17",1023,219720.6,2177,254212.71000000002,177,166782.20000000001,3377,640715.51]
["2017-18$",339,53617.729999999996,576,62902.489999999991,57,56024.7,972,172544.92]
["2017-04-01",88,20353.77,194,24969.46,19,18495.5,301,63818.73]
["2017-05-01",156,12433.26,133,8226.41,12,12729.2,301,33388.870000000003]
["2017-06-01",95,20830.7,249,29706.62,26,24800,370,75337.320000000007]
[]
["$ indicates as on June 30, 2017"]
["Source: SEBI"]

{"sheet":"13","index":13,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[9,0,9,4]]}
["Table 13: Trading in the Corporate Debt Market"]
["Year/ Month","BSE",null,"NSE",null,"MSEI"]
[null,"No. of Trades","Traded Value (₹ crore)","No. of Trades","Traded Value (₹ crore)","No. of Trades","Traded Value (₹ crore)"]
["2016-17",24372,292153.95,64123,1178508.53,0,0]
["2017-18$",6700,103294.67000000001,15644,331355.61,0,0]
["2017-04-01",2287,37605.480000000003,4718,101728.74,0,0]
["2017-05-01",2123,30364.53,4942,95578.15,0,0]
["2017-06-01",2290,35324.660000000003,5984,134048.72,0,0]
[]
["$ indicates as on June 30, 2017"]
["Source: SEBI",null,null,null," "]

{"sheet":"14","index":14,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[10,0,10,5],[1,0,3,0],[1,1,1,8],[1,9,2,10],[1,11,2,12],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8]]}
["Table 14: Ratings Assigned for Long-term Corporate Debt Securities (Maturity ≥ 1 year)"]
["      Grade\nPeriod","Investment Grade",null,null,null,null,null,null,null,"Non-Investment Grade",null,"Total"]
[null,"Highest Safety (AAA)",null,"High Safety (AA)",null,"Adequate Safety (A)",null,"Moderate Safety (BBB)"]
[null,"No. of issue","Amount              (₹ crore)","No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)"]
["2016-17",244,1308971.3499999999,418,309641.03999999998,252,61125.48,173,10267.570000000002,117,12714.49,1204,1700855.69]
["2017-18$",69,615315.97,121,110033.47,35,6343.2699999999995,26,2148.34,25,2808.57,276,736649.62000000011]
["2017-04-01",26,331327.81999999995,44,37500.82,18,3446.0199999999995,8,437.71,9,788.32,105,373500.69]
["2017-05-01",15,133934.04999999999,29,45167.65,6,1365,5,363.65999999999997,9,1482.48,64,182312.84]
["2017-06-01",28,150054.09999999998,48,27365,11,1532.25,13,1346.97,7,537.77,107,180836.09000000003]
[]
["$ indicates as on June 30, 2017"]
["Source: Credit Rating Agencies."]

{"sheet":"15","index":15,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,0,9,5],[10,0,10,12],[0,0,0,12],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,12]]}
["Table 15: Review of Accepted Ratings of Corporate Debt Securities (Maturity ≥ 1 year)"]
["   Grade \n\nPeriod","Upgraded",null,"Downgraded",null,"Reaffirmed",null,"Rating Watch",null,"Withdrawn/ Suspended",null,"Total"]
[null,"No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)","No. of issue","Amount (₹ crore)"]
["2016-17",368,79324.570000000007,189,177619.89,2647,9057498.6415999997,59,50382.75,600,261346.32,3850,9889175.1516000014]
["2017-18$",75,46167.43,71,146418.44,752,2284827.8889999995,14,57808.270000000004,221,58746.25,1133,2593968.2790000001]
["2017-04-01",11,19557.169999999998,14,9678.7999999999993,181,807639.49600000004,2,1591.26,64,24349.25,272,862815.97600000002]
["2017-05-01",24,8266.27,27,117005.36,137,545575.64999999979,9,55832.14,87,19714.71,284,746394.12999999966]
["2017-06-01",40,18343.990000000002,30,19734.28,434,931612.74300000002,3,384.87,70,14682.289999999999,577,984758.17300000018]
[]
["$ indicates as on June 30, 2017"]
["Source: Credit Rating Agencies."]

{"sheet":"16","index":16,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,4],[8,0,8,2],[9,0,9,3]]}
["Table 16: Distribution of Turnover on Cash Segments of Exchanges (₹ crore)"]
["Stock Exchanges","2016-17","2017-18$","2017-07-01"]
["Ahmedabad",0,0,0]
["BSE",998260.58000000007,252110.53999999998,85934.520000000019]
["Calcutta",0,0,0]
["MSEI",248.08361863000002,6.4758022500000001,0.90657775000000007]
["NSE",5055913.2878522538,1546916.9325370898,486304.73794642993]
[]
["$ indicates as on June 30, 2017"]
["Source:  Exchanges."]

{"sheet":"17","index":17,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[[10,0,10,5],[0,0,0,15],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,12,2,12],[1,13,1,15]]}
["Table 17: Trends in Cash Segment of BSE "]
["Year/      Month","No. of Companies Listed ","No. of Companies Permitted* ","No. of companies traded ","No. of Trading Days","No. of Trades (Lakh)","Traded Quantity (Lakh)","Turnover (₹ crore)","Average Daily Turnover (₹ crore)","Average Trade Size (`)","Demat Securities Traded (Lakh)","Demat Turnover (₹ crore) ","Market  Capitalisation (₹ crore) ","S&P BSE Sensex "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"High","Low","Close"]
["2016-17",5834,70,2948,248,3918.55,707231.15999999992,998260.58000000007,4025.2442741935488,25475.254367049034,707231.15999999992,998260.41999999993,12154525.460000001,29824.62,24523.200000000001,29620.5]
["2017-18$",5794,56,2725,61,862.92000000000007,175692.87,252110.53999999998,4132.9596721311473,29215.980623928055,175692.87,252110.49,12596811.99,31522.87,29241.48,30921.61]
["2017-04-04",5828,56,2978,18,287.36,57778.279999999992,75070.400000000009,4170.5777777777785,26124.164810690425,57778.279999999992,75070.38,12484962.9,30184.22,29241.48,29918.400000000001]
["2017-05-04",5783,56,2829,22,314.87,63338.030000000006,91105.619999999966,4141.1645454545442,28934.360212151034,63338.030000000006,91105.609999999957,12580118.73,31255.279999999999,29804.12,31145.8]
["2017-06-04",5794,56,2725,21,260.69000000000005,54576.55999999999,85934.520000000019,4092.1200000000008,32964.256396486249,54576.55999999999,85934.500000000015,12596811.99,31522.87,30680.66,30921.61]
[]
["Notes: 1. * Excludes Mutual Fund Schemes from Feb 2013. 2. Market capitalisation pertains to the number of companies traded."]
["$ indicates as on June 30, 2017"]
["Source: BSE ."]

{"sheet":"18","index":18,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,0,11,5],[1,9,3,9],[1,10,3,10],[1,11,3,11],[1,12,3,12],[1,13,1,15],[2,13,3,13],[2,14,3,14],[2,15,3,15],[0,0,0,15],[1,0,3,0],[1,1,3,1],[1,2,3,2],[1,3,3,3],[1,4,3,4],[1,5,3,5],[1,6,3,6],[1,7,3,7],[1,8,3,8]]}
["Table 18: Trends in Cash Segment of NSE "]
["Year/         Month","No. of Companies Listed ","No. of Companies Permitted ","No. of Companies Traded","No. of Trading Days","No. of Trades (Lakh)","Traded Quantity (Lakh)","Turnover (₹ crore)","Average Daily Turnover (₹ crore)","Average Trade Size (`)","Demat Securities Traded (Lakh)","Demat Turnover (₹ crore) ","Market  Capitalisation (₹ crore) ","Nifty 50 Index "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"High","Low","Close"]
[]
["2016-17",1817,4,1665,248,19759.718280000001,2624533.6883799997,5055913.2878522538,20386.747128436506,25586.970503368197,2624533.6883799997,5055913.2878522538,11978420.9020945,9218.4,7516.85,9173.75]
["2017-18$",1820,4,1666,61,5567.74521,798581.67329999991,1546916.9325370898,25359.293976017867,27783.543861862348,798581.67329999991,1546916.9325370898,12430129.1713464,9709.2999999999993,9075.15,9520.9]
["2017-04-19",1831,4,1668,18,1673.04198,249260.34360999995,472110.19459065993,26228.344143925551,28218.669957741284,249260.34360999995,472110.19459065993,12303874.7516181,9367.15,9075.15,9304.0499999999993]
["2017-05-17",1814,4,1669,22,2093,295182,588502,26750.082811158591,28118.696320624746,295182,588502,12416788.8648584,9649.6,9269,9621.25]
["2017-06-17",1820,4,1666,21,1801.7032300000001,254139.32968999998,486304.73794642993,23157.368473639519,26991.389583423785,254139.32968999998,486304.73794642993,12430129.1713464,9709.2999999999993,9448.75,9520.9]
[]
["Notes: 1. Demat turnover includes turnover of all securities which are available for trading in Demat mode. 2. Market capitalisation pertains to the number of companies traded."]
["$ indicates as on June 30, 2017"]
["Source: NSE"]

{"sheet":"19","index":19,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[27,0,27,4],[28,0,29,6],[0,0,0,5],[1,0,1,5],[2,0,3,0],[2,1,3,1],[2,2,2,3],[2,4,2,5]]}
["Table 19: City-wise Distribution of Turnover on Cash Segments of BSE and NSE"]
["          (Percentage share in Turnover)"]
["S.No.","City","BSE",null,"NSE"]
[null,"Stock Exchange/City","2016-17","2017-07-01","2016-17","2017-07-01"]
[1,"Ahmedabad",3.1720252866837217,2.9212776989260627,2.9890138466302947,2.9911498714943674]
[2,"Bengaluru",0.34610185961177031,0.33424827589748896,6.3042184739477785,6.3935521478756918]
[3,"Vadodra",0.87030258284593931,0.83435339327820723,0.33666970244081923,0.41137023840887393]
[4,"Bhubneshwar",1.7430937996629273E-2,1.9063665734837899E-2,2.9313204315614683E-4,3.4757246033413766E-4]
[5,"Chennai",0.69166281680534702,1.2357630865908984,1.0372280159209051,0.87796628401808696]
[6,"Ernakulum",0.113061823364839,0.11975410243148336,1.0785203489947173,0.90001021452685936]
[7,"Coimbatore",3.75825163110802E-2,3.6086308786326807E-2,8.6247767511040421E-2,8.340598630382598E-2]
[8,"New Delhi",3.0965432691214123,2.9372487204041868,6.7074603316296697,6.3642298651864726]
[9,"Guwahati",5.4350372750387524E-2,6.0519327786393649E-2,1.3543654816490045E-3,6.2175496995827448E-4]
[10,"Hyderabad",0.35471520198509449,0.23272546477909731,3.5840748303494041,3.4467204473079742]
[11,"Indore",0.32935707905544903,0.32211711493102485,0.45214203499069167,0.47764306146263469]
[12,"Jaipur",0.59684821799753973,0.59119849059717489,0.47678180964731948,0.51358618361438901]
[13,"Kanpur",0.33258017078442514,0.27996316371296182,0.11508452135719188,0.10533708894826656]
[14,"Kolkata",3.4846407502288228,2.980095968681133,4.7899774342137507,4.8175122995040311]
[15,"Ludhiana",9.4769868795682999E-2,8.1145714903788538E-2,0.10241025593190738,7.2264077112140571E-2]
[16,"Mangalore",1.9182141141532872E-2,1.7336477298884451E-2,4.512396345860445E-4,5.0755488734897437E-4]
[17,"Mumbai",55.942020611588163,61.595843093265046,59.972635127767873,60.590224203276179]
[18,"Patna",4.9710910691100181E-2,5.6657360047375073E-2,4.983533178613297E-3,2.3043760309988956E-3]
[19,"Pune",0.32183505927623784,0.28713813730379106,0.14834695597098868,0.14755877339146845]
[20,"Rajkot",1.7529716288304824,1.6706720793729983,1.2407315386510989,1.2955441647019934]
[21,"Others",28.322306894134343,23.386792355270845,10.571374733706534,10.508143834518094]
[null,"Total",100,100.00000000000003,100,100]
[]
["Notes: "]
["1. The city-wise distribution of turnover is based on the cities uploaded in the UCC database of the Exchange for clientele trades and member's registered office city for proprietary trades."]
[]
["Source: BSE and NSE."]

{"sheet":"20","index":20,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,5]]}
["Table 20: Category-wise Share of Turnover in Cash Segment of BSE"]
["Year/Month","Percentage Share in Turnover"]
[null,"Proprietary","FPI","Mutual Funds","Banks","Others"]
["2016-17",13.487552802180911,12.858440464135123,4.6291595194783861,8.6556316029854294E-2,68.938290898175708]
["2017-18$",16.088141420821035,16.533458370263229,7.4324987395954221,0.32596749051329243,59.619933978807026]
["2017-04-04",18.060795844293921,15.557794942928602,5.6656043721427496,7.7179977903151772E-2,60.638624862731575]
["2017-05-04",17.34624581445911,15.395740161861815,8.2370237109195532,6.9574058394495902E-2,58.951416254365029]
["2017-06-04",13.03106545450968,18.591955720525004,8.1230793589013714,0.81512439926432689,59.438775066799629]
[]
["$ indicates as on June 30, 2017"]
["Source: BSE. "]

{"sheet":"21","index":21,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,5]]}
["Table 21: Category-wise Share of Turnover in Cash Segment of NSE"]
["Year/Month","Percentage Share in Turnover"]
[null,"Proprietary","FPI","Mutual Funds","Banks","Others"]
["2016-17",16.917932653270125,20.271183814089273,6.2137977386162628,0.42218466828211887,56.597085794024338]
["2017-18$",16.989999999999998,17.71,6.98,0.61,57.71]
["2017-04-18",16.6152857013893,15.498526184541999,7.2181070516476797,0.59950798906228397,60.668081062421024]
["2017-05-17",17.431307168043599,18.4424365122522,6.8825704680528297,0.597030048999318,57.243685851651364]
["2017-06-17",16.8295507501463,18.985251854645,6.8537180004421501,0.62384268928296804,56.71]
[]
["$ indicates as on June 30, 2017"]
["Source: NSE. "]

{"sheet":"22","index":22,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,0,39,1],[0,0,0,9],[34,0,34,9],[35,0,35,9],[36,0,36,9],[37,0,37,9],[38,0,38,9]]}
["Table 22: Component Stocks: S&P BSE Sensex during July-2017"]
["S.No.","Name of Security","Issued Capital     (₹ crore)","Free Float Market Capitalisation (₹ crore)","Weightage (Percent)   ","Beta","R2","Daily Volatility (Percent)","Monthly Return (Percent)","Impact Cost (Percent) "]
[1,"HDFC BANK   ",514.78,335302.03370000003,11.40824349067451,0.75,0.32975399999999999,0.88,1.1571310496831,0.03]
[2,"ITC LTD.    ",1214.74,275375.09891900001,9.3693024914585585,1.05,0.23601800000000001,1.46,3.8313562039115001,0.03]
[3,"HDFC        ",318.58,256898.14322,8.7406465681568957,1.26,0.38636300000000001,1.37,2.9423940387860998,0.03]
[4,"RELIANCE    ",3251.57,228877.451096,7.78727663180325,0.83,0.15357599999999999,1.43,2.9576309115321,0.03]
[5,"INFOSYS LTD ",1148.47,186974.801863,6.3615900050943415,0.56000000000000005,8.1855999999999998E-2,1.33,-4.2274425507958,0.04]
[6,"ICICI BANK  ",1282.49,185967.89425499999,6.3273311995693078,1.75,0.367199,1.95,-11.0940851976708,0.03]
[7,"LARSEN & TOU",186.68,135465.032267,4.6090328040083559,1.1599999999999999,0.38250699999999999,1.26,-4.0886489558174999,0.03]
[8,"TCS LTD.    ",197.04,125787.098929,4.2797529043665774,0.47,4.8974999999999998E-2,1.44,-7.0744983984120999,0.03]
[9,"KOTAK MAH.BK",951.61,103640.141848,3.5262296520035359,0.78,0.20274900000000001,1.17,-0.93831000518399998,0.05]
[10,"MARUTISUZUK ",151.04,95936.862208000006,3.2641349404381899,1.3,0.37340600000000002,1.44,4.1580617887899997E-2,0.03]
[11,"STATE BANK  ",863.21,94469.155199999994,3.214197996318088,1.37,0.32272800000000001,1.63,-5.1810778028071001,0.03]
[12,"AXIS BANK   ",479.39,86587.242742000002,2.9460255205928245,1.4,0.28991600000000001,1.75,0.3695060287825,0.03]
[13,"TATA MOTORS ",577.47,83668.126669999998,2.8467061500556534,1.75,0.33554800000000001,2.04,-9.1768164636707006,0.04]
[14,"HIND UNI LT ",216.45,77251.711679999993,2.6283954415419464,0.63,0.14429600000000001,1.1200000000000001,1.3873265841769,0.05]
[15,"MAH & MAH   ",310.55,62776.097535000001,2.1358802932712777,1.1000000000000001,0.31056699999999998,1.34,-4.8504959932220002,0.05]
[16,"SUN PHARMA. ",239.92,59866.287525,2.0368775501641996,0.71,7.3014999999999997E-2,1.78,10.5903470283207,0.04]
[17,"BHARTI ARTL ",1998.7,50015.268929999998,1.7017086353717739,0.74,9.1554999999999997E-2,1.64,1.9768692845614999,0.06]
[18,"ASIAN PAINTS",95.92,49777.628170000004,1.6936231978232066,1.08,0.23898,1.5,-4.2035398230087999,0.05]
[19,"HEROMOTOCO  ",39.94,47246.073594000001,1.6074901353593531,1.05,0.259494,1.39,-1.2316981938655001,0.05]
[20,"POWER GRID  ",5231.59,46263.473529000003,1.5740583643922192,0.81,0.16500799999999999,1.34,1.3233878729547,0.08]
[21,"ONGC CORPN  ",6416.62,42392.025176000003,1.4423370473896771,0.74,3.0308999999999999E-2,2.86,-11.1550409488844,0.04]
[22,"NTPC LTD    ",8245.4599999999991,39194.817878000002,1.3335559614438044,0.77,0.16211300000000001,1.3,-0.99968759762570003,7.0000000000000007E-2]
[23,"BAJAJ AUTO  ",289.37,37951.625988,1.2912578708827394,0.87,0.23360800000000001,1.22,-1.8794282599904999,0.06]
[24,"TATA STEEL  ",971.22,36478.981081999998,1.2411529207947212,1.61,0.284522,2.04,7.8134284016636002,0.03]
[25,"DR.REDDY'S  ",82.88,32889.353384000002,1.1190202084822956,0.4,3.2981000000000003E-2,1.49,6.5241130105028997,0.04]
[26,"WIPRO LTD.  ",973.23,32735.416252999999,1.1137826850073407,0.43,3.8419999999999999E-3,4.6500000000000004,-51.829098017313498,0.06]
[27,"ADANI PORTS ",414.19,32276.511752999999,1.0981690180778692,1.71,0.28569,2.16,6.9331759846584999,0.06]
[28,"COAL INDIA  ",6207.41,30316.985556,1.0314985248063235,0.57999999999999996,8.7848999999999997E-2,1.33,-7.2540827952904996,0.05]
[29,"CIPLA LTD.  ",160.91,28098.144428,0.95600515670467057,0.59,8.2715999999999998E-2,1.38,7.7244461717839004,7.0000000000000007E-2]
[30,"LUPIN LTD.  ",90.34,25386.138241000001,0.86373244786332326,0.75,9.8779000000000006E-2,1.61,-8.6806751636237998,0.05]
[31,"TATA MOTORS LTD DVR",101.7,13254.969083,0.45098418608317148,1.68,0.31473899999999999,2.02,-8.5287476116031993,0.09]
[]
["Notes: 1. Beta & R2 are calculated for the trailing 12 months. Beta measures the  degree to which any portfolio of stocks is affected as compared to the effect on the market as a whole."]
["2. The coefficient of determination (R2) measures the strength of relationship between two variables the return on  a security versus that of the market."]
["3. Volatility is the standard deviation of the daily returns for the trailing 12 months."]
["4. Impact cost is calculated as the difference between actual buy price and ideal buy price, divided by ideal buy price, multiplied by 100. Hence ideal price is calculated as (best buy + best sell)/2."]
["5. The above is calculated for a month for the portfolio size of ` 5 lakh.  It is calculated for the current month."]
["Source: BSE."]

{"sheet":"23","index":23,"n_rows":61,"n_cols":10,"rows_kept":61,"cut":false,"hidden":false,"merged":[[59,0,59,9],[60,0,60,1],[0,0,0,9],[54,0,54,9],[55,0,55,9],[56,0,56,9],[57,0,57,9],[58,0,58,9]]}
["Table 23: Component Stocks: Nifty 50 Index during July-2017"]
["S.No.","Name of Security","Issued Capital     (₹ crore)","Free Float Market Capitalisation (₹ crore)","Weightage (Percent)   ","Beta","R2","Daily Volatility (Percent)","Monthly Return (Percent)","Impact Cost (Percent) "]
[1,"HDFC BANK LTD.",5129818234,334751.28999999998,9.3000000000000007,0.77,0.35,0.61,0.97,0.03]
[2,"I T C LTD.",12147383072,275205.03999999998,7.65,0.98,0.21,1.34,3.8,0.02]
[3,"HOUSING DEVELOPMENT FINANCE CORPORATION LTD.",3177763090,256596.43,7.13,1.21,0.36,0.95,2.87,0.01]
[4,"RELIANCE INDUSTRIES LTD.",32514345720,228835.97,6.36,0.78,0.13,1.28,2.93,0.02]
[5,"INFOSYS LTD.",11484723320,186954.87,5.19,0.53,0.08,1.02,-4.25,0.02]
[6,"ICICI BANK LTD.",12818101330,185958.61,5.17,1.63,0.36,1.06,-2.23,0.02]
[7,"LARSEN & TOUBRO LTD.",1866180922,138572.14000000001,3.85,1.1399999999999999,0.37,1.1100000000000001,-4.1500000000000004,0.02]
[8,"TATA CONSULTANCY SERVICES LTD.",1970427941,125680.69,3.49,0.46,0.05,1.6,-7.24,0.02]
[9,"KOTAK MAHINDRA BANK LTD.",9205141265,116131.14,3.23,0.81,0.23,0.94,-1.07,0.02]
[10,"STATE BANK OF INDIA",8632050393,101572.91,2.82,1.36,0.33,1.05,-5.08,0.02]
[11,"MARUTI SUZUKI INDIA LTD.",1510400300,95932.89,2.67,1.32,0.4,0.93,0.09,0.01]
[12,"AXIS BANK LTD.",4793137128,88030.399999999994,2.4500000000000002,1.34,0.28000000000000003,1.31,0.64,0.02]
[13,"TATA MOTORS LTD.",5774696856,81179.97,2.2599999999999998,1.76,0.36,1.5,-9.16,0.02]
[14,"HINDUSTAN UNILEVER LTD.",2164349639,77108.850000000006,2.14,0.6,0.13,1.22,1.18,0.01]
[15,"INDUSIND BANK LTD.",5982921560,74326.91,2.06,1.1499999999999999,0.33,0.75,-0.12,0.02]
[16,"MAHINDRA & MAHINDRA LTD.",3105461920,62820.39,1.75,1.1299999999999999,0.33,0.71,-4.82,0.01]
[17,"SUN PHARMACEUTICAL INDUSTRIES LTD.",2399291181,61331.16,1.7,0.69,7.0000000000000007E-2,1.51,10.79,0.02]
[18,"YES BANK LTD.",4569894450,53504.32,1.49,1.53,0.34,1.49,2.25,0.02]
[19,"BHARTI AIRTEL LTD.",19987000510,50087.82,1.39,0.74,0.1,0.9,2.19,0.02]
[20,"ASIAN PAINTS LTD.",959197790,49723.519999999997,1.38,1.08,0.24,0.86,-4.1900000000000004,0.02]
[21,"HCL TECHNOLOGIES LTD.",2853975808,48568.959999999999,1.35,0.46,0.06,1.21,-1.54,0.02]
[22,"HERO MOTOCORP LTD.",399393676,48044.61,1.33,1.1000000000000001,0.28000000000000003,1.08,-1.18,0.01]
[23,"POWER GRID CORPORATION OF INDIA LTD.",52315896480,46263.47,1.29,0.81,0.17,1.04,1.25,0.03]
[24,"VEDANTA LTD.",3717194239,46288.36,1.29,1.81,0.26,1.82,4.3600000000000003,0.02]
[25,"OIL & NATURAL GAS CORPORATION LTD.",64166175900,44410.69,1.23,0.6,0.08,1.18,-11.13,0.02]
[26,"ULTRATECH CEMENT LTD.",2745117460,41299.14,1.1499999999999999,1.3,0.34,1.2,-5.63,0.02]
[27,"INDIAN OIL CORPORATION LTD.",48559049640,39280.39,1.0900000000000001,1.2,0.2,1.61,-10.3,0.02]
[28,"NTPC LTD.",82454644000,39318.5,1.0900000000000001,0.78,0.17,0.89,-0.78,0.03]
[29,"BAJAJ AUTO LTD.",2893670200,37961.019999999997,1.05,0.9,0.26,0.74,-1.92,0.02]
[30,"TATA STEEL LTD.",9712154390,36572.82,1.02,1.67,0.31,1.36,8.1300000000000008,0.02]
[31,"EICHER MOTORS LTD.",272102490,36051.69,1,1.29,0.23,1.18,-4.91,0.02]
[32,"INDIABULLS HOUSING FINANCE LTD.",848625648,34703.440000000002,0.96,1.24,0.19,1.35,-7.28,0.03]
[33,"BHARAT PETROLEUM CORPORATION LTD.",14461684960,33288.480000000003,0.92,0.93,0.15,1.3,-13.9,0.02]
[34,"WIPRO LTD.",9729725632,32677.77,0.91,0.43,7.0000000000000007E-2,1.2,-3.51,0.03]
[35,"DR. REDDY'S LABORATORIES LTD.",828708565,32547.91,0.9,0.41,0.04,1.1299999999999999,6.59,0.02]
[36,"COAL INDIA LTD.",62074091770,31839.35,0.88,0.63,0.1,0.81,-6.97,0.03]
[37,"ADANI PORTS AND SPECIAL ECONOMIC ZONE LTD.",4141903522,29322.5,0.81,1.75,0.3,1.19,7.09,0.03]
[38,"CIPLA LTD.",1609099350,28161.49,0.78,0.56999999999999995,0.08,1.31,7.6,0.02]
[39,"HINDALCO INDUSTRIES LTD.",2243352013,27843.919999999998,0.77,1.74,0.28000000000000003,1.37,-4.8600000000000003,0.02]
[40,"ZEE ENTERTAINMENT ENTERPRISES LTD.",960448720,26899.24,0.75,1.26,0.24,1.1100000000000001,-4.5599999999999996,0.02]
[41,"BHARTI INFRATEL LTD.",18496082460,26325.29,0.73,0.65,0.04,1.1399999999999999,2.17,0.03]
[42,"LUPIN LTD.",903342124,25371.29,0.7,0.79,0.11,1.36,-8.7100000000000009,0.02]
[43,"TECH MAHINDRA LTD.",4871539365,23819.88,0.66,0.78,0.1,1.53,-2.0499999999999998,0.02]
[44,"GAIL (INDIA) LTD.",16913032000,23230.22,0.65,0.82,0.14000000000000001,1.3,-12.69,0.03]
[45,"BOSCH LTD.",305207400,21358.95,0.59,1.1399999999999999,0.28000000000000003,1.18,-0.05,0.03]
[46,"AUROBINDO PHARMA LTD.",585882409,19252.560000000001,0.53,1.36,0.19,1.68,19.239999999999998,0.02]
[47,"AMBUJA CEMENTS LTD.",3971290458,18113.75,0.5,1.44,0.39,1.06,2.2000000000000002,0.03]
[48,"BANK OF BARODA",4608319196,15271.16,0.42,1.56,0.21,1.73,-9.2100000000000009,0.03]
[49,"TATA POWER CO. LTD.",2704773510,14597.26,0.41,0.99,0.22,1.47,-0.56000000000000005,0.04]
[50,"ACC LTD.",1877871730,13250.69,0.37,1.27,0.34,1.1399999999999999,-4.21,0.02]
[51,"TATA MOTORS LTD DVR",1017004582,13388.87,0.37,1.73,0.35,1.58,-8.5399999999999991,0.04]
[]
["Notes: 1. Beta & R2 are calculated for the the trailing 12 months. Beta measures the  degree to which any portfolio of stocks is affected as compared to the effect on the market as a whole."]
["2. The coefficient of determination (R2) measures the strength of relationship between two variables the return on  a security versus that of the market."]
["3. Volatility is the standard deviation of the daily returns for the the trailing 12 months."]
["4. Impact cost is calculated as the difference between actual buy price and ideal buy price, divided by ideal buy price, multiplied by 100. Hence ideal price is calculated as (best buy + best sell)/2."]
["5. The above is calculated for a month for the portfolio size of `5 lakh.  It is calculated for the current month."]
["6. As per NSE circular dated February 22, 2016, the equity securities with Differential Voting Rights (DVRs) would be eligible for inclusion in an index subject to fulfilment of the eligibility criteria laid down by NSE."]
["Source: NSE."]

{"sheet":"24","index":24,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,2,0],[1,1,1,3],[1,4,1,6],[9,0,9,6]]}
["Table 24: Advances/Declines in Cash Segment of BSE and NSE"]
["Year/ Month","BSE",null,null,"NSE"]
[null,"Advances","Declines","Advance / Decline Ratio","Advances","Declines","Advance / Decline Ratio"]
["2016-17",2137,1650,1.2951515151515152,993,627,1.5837320574162679]
["2017-18$",2417,1327,1.8214016578749057,1142,388,2.9432989690721651]
["2017-04-04",2511,1077,2.331476323119777,1327,351,3.7806267806267808]
["2017-05-01",1616,1941,0.83256053580628542,766,931,0.82]
["2017-06-04",1310,2171,0.60340856748042382,668,1022,0.6536203522504892]
[]
["Note: Advance/Decline is calculated based on the average price methodology.                                                                           ",null,null,null,null,null,null,null,null,null,null,"`"]
["Source: BSE and NSE"]

{"sheet":"25","index":25,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[9,0,10,6],[0,0,0,6],[1,0,3,0],[1,1,1,3],[1,4,1,6],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6]]}
["Table 25: Trading Frequency in Cash Segment of BSE and NSE"]
["Month"," BSE",null,null,"NSE"]
[null,"No. of Companies Listed ","No. of companies Traded ","Percent of Traded to Listed","No. of Companies Listed","No. of companies Traded ","Percent of Traded to Listed"]
[]
["2016-17",5834,2948,50.531367843675014,1817,1665,91.634562465602642]
["2017-18$",5828,2978,51.098146877144821,1831,1668,91.097760786455481]
["2017-04-04",5828,2978,51.098146877144821,1831,1668,91.097760786455481]
["2017-05-05",5783,2829,48.919246066055685,1814,1669,92.006615214994497]
["2017-06-05",5794,2725,47.031411805315841,1820,1666,91.538461538461533]
["Note: At NSE, number of companies traded also includes the number of companies not available for trading but permitted to trade only in the first week of every month."]
[]
["$ indicates as on June 30, 2017"]
["Source: BSE and NSE"]

{"sheet":"26","index":26,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,6],[7,0,8,6],[9,0,9,2],[9,3,9,5]]}
["Table 26: Daily Volatility of Major Indices  (percent)"]
["Year/        Month","BSE Sensex","BSE 100 ","BSE 500","Nifty 50","Nifty Next 50","Nifty 500"]
["2016-17",0.76807487248051698,0.80218025330334042,0.79644016852872535,0.78266424176355576,0.96894228239080127,0.80209967984939878]
["2017-18$",0.5087020338759084,0.51505683042923878,0.5454836568993362,0.48,0.77,0.53]
["2017-04-04",0.57641998710815456,0.51385813202658237,0.48730611827302289,0.48400798196830025,0.58023748168739364,0.45367459233534146]
["2017-05-04",0.58043233858866461,0.64030642922381897,0.70983496954537129,0.5675048528617026,1.0185463151440759,0.68839166564612142]
["2017-06-04",0.3384528305976503,0.35441280983265783,0.38670928645025415,0.34,0.53,0.38]
["Note: Volatility is calculated as the standard deviation of the natural log of daily returns in indices for the respective period. "]
[]
["$ indicates as on June 30, 2017."]
["Source: BSE and NSE."]

{"sheet":"27","index":27,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[16,0,16,11],[0,0,0,11],[1,1,1,5],[1,6,1,10],[3,0,3,10],[10,0,10,10]]}
["Table 27: Percentage Share of Top ‘N’ Securities/Members in Turnover of Cash Segment  (percent)"]
["Year/Month","BSE",null,null,null,null,"NSE"]
["Top",5,10,25,50,100,5,10,25,50,100]
["Securities"]
["2016-17",10.0146,15.5944,28.3171,40.993499999999997,55.793500000000002,10.741703436208812,19.203194493761831,33.795316234396168,48.859419684662356,67.722091628948988]
["2017-18$",12.4442,18.5091,30.574200000000001,43.0229,57.520600000000002,9.7274898642056691,16.600178600466588,31.537414530025977,46.19001513239364,64.879664829975226]
["2017-04-04",12.8415,18.719799999999999,30.6358,42.706000000000003,56.6357,13.89261824964346,24.334909079958418,40.599696565046187,57.243974197238721,74.511379225617617]
["2017-05-04",11.9795,18.3444,30.544,43.490699999999997,59.6738,10.110440524450469,17.166786660785988,32.206219299359688,47.999426619665932,67.258441549629197]
["2017-06-04",23.319400000000002,29.771699999999999,39.977200000000003,50.427799999999998,63.522199999999998,10.202479368029129,17.414184504146871,32.7478717775519,48.060537544593259,66.844713822379802]
[]
["Members"]
["2016-17",19.38,29.36,49.27,66.13,80.400000000000006,18.498956237186583,28.897726520260065,50.722319273866958,67.895106592033784,81.704425693069851]
["2017-18$",22.93,35.26,56.53,71.430000000000007,83.63,18.947546601475064,30.362139259302488,51.624617214346301,68.383517861731463,81.701424878476388]
["2017-04-04",20.440000000000001,31.98,53.6,69.22,81.63,18.093423609092689,29.434330983046586,51.403704736997661,69.180092046794257,82.78272068117694]
["2017-05-04",22.77,35.020000000000003,54.74,70.41,83.03,19.276072417880233,30.540272901689253,52.247491538912868,69.122000187580554,82.178600936110456]
["2017-06-04",32.630000000000003,43.36,63.64,76.61,86.61,19.239602255361969,31.745430657465949,52.809883843457875,69.272237370827909,82.03347318442286]
["Notes: 1. Data for Top N scrips has been compiled for all markets except Auction market & Retail Debt Market and includes series EQ, BE,BT, BL and IL."]
["$ indicates as on June 30, 2017"]
["Source: BSE and NSE"]

{"sheet":"28","index":28,"n_rows":9,"n_cols":17,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,16]]}
["Table 28: Settlement Statistics for Cash Segment of BSE "]
["Year/     Month\n","No. of Trades(Lakh)","Quantity Settled (Lakh)","Delivered Quantity   (Lakh)","Percent of Delivered Quantity to Traded Quantity","Value Settled (` crore)","Delivered Value      (` crore)","Percent  of Delivered Value to Total Turnover","Delivered Quantity in Demat Mode (Lakh)","Percent of Demat Delivered Quantity to Total Delivered Quantity","Delivered Value in Demat Mode     (` crore)","Percent of Demat Delivered Value to Total Delivered Value","Short Delivery (Auctioned quantity) (Lakh)","Percent of Short Delivery to Delivery Quantity","Funds Pay-in (` crore)","Securities Pay-in (` crore)","SettlementGuarantee Fund (`crore)"]
["2016-17",3918.5088299999998,707223,303781.60625000001,41.942237721663382,998260.58000000007,464996.29739866097,37.438058851733331,303449.16791000002,99.94442952609478,464969.74684493802,99.99,714.67051000000004,0.2445689483924621,117489.5380093,298363.24004866101,148.66]
["2017-18$",862.91859999999997,175694,71276.162889999992,40.576751032317141,252110.53999999998,96249.505238679005,38.119573155670345,71276.036859999993,99.993333333333339,96249.380676678993,99.993333333333339,127.85800999999999,0.17908757490969304,37884.878771300006,71276.162889999992,181.73]
["2017-04-04",287.35000000000002,57778,23452.3835,40.590507632662955,75070.400000000009,26771.100151385999,35.661326103745274,23452.25747,99.99,26770.975589385995,99.99,41.57,0.17725372516132454,10589.514006700001,23452.3835,149.62]
["2017-05-04",314.87893000000003,63339,25591.070489999998,40.403338369724814,91105.619999999966,32596.855593134002,35.779192977484833,25591.070489999998,99.99,32596.855593134002,99.99,47.612380000000002,0.18605075555008566,13409.2344619,25591.070489999998,180.7]
["2017-06-04",260.68967000000004,54577,22232.708900000001,40.736407094563646,85934.520000000019,36881.549494159,42.918200385780928,22232.708900000001,100,36881.549494159,100,38.675629999999998,0.17395824401766893,13886.130302699999,22232.708900000001,181.73]
["$ indicates as on June 30, 2017"]
["Source: BSE."]

{"sheet":"29","index":29,"n_rows":9,"n_cols":17,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,16]]}
["Table 29: Settlement Statistics for Cash Segment of NSE "]
["Year/     Month\n","No. of Trades      (Lakh)","Quantity Settled (Lakh)","Delivered Quantity   (Lakh)","Percent of Delivered Quantity to Traded Quantity","Value Settled (` crore)","Delivered Value      (` crore)","Percent  of Delivered Value to Total Turnover","Delivered Quantity in Demat Mode (Lakh)","Percent of Demat Delivered Quantity to Total Delivered Quantity","Delivered Value in Demat Mode     (` crore)","Percent of Demat Delivered Value to Total Delivered Value","Short Delivery (Auctioned quantity) (Lakh)","Percent of Short Delivery to Delivery Quantity","Funds Pay-in             (` crore)","Securities Pay-in      (` crore)","Settlement Guarantee Fund        (` crore)"]
["2016-17",19728.340499999998,2584979.49389,725682.13911999995,28.099646049323507,4998105.6923700003,1479963.1264537419,29.567869905478531,724494.50391999993,100,1478866.6969071468,100,1187.6369654425505,0.17419827885274486,409421.97000000003,1479963.1264537419,197.17]
["2017-18$",5577.3525099999997,791677.81391000003,217294.26874,27.46612407388902,1551580.9068999998,455203.68685000006,29.393801717137407,217006.92974999998,100,454867.6738799999,100,287.33898999999997,0.13241005267943523,108900.37,455203.68685000006,200.285]
["2017-04-14",1678.94715,249467.13589999996,72463.982239999998,29.047506389397725,474912.10229999991,143865.50703000001,30.293080831854819,72373.597860000009,100,143748.49127999999,100,90.384379999999993,0.12488584604407835,31734.769999999997,143865.50703000001,197.84]
["2017-05-17",2051.2986999999998,289353.48480000003,78718.365609999993,27.204913624734743,581636.72600000002,166371.44521000001,28.604013084620796,78619.324139999982,100,166252.20267999999,100,99.041470000000004,0.12597598756208289,39228.170000000006,166371.44521000001,202.73]
["2017-06-19",1847.1066599999999,252857.19321000003,66111.920890000009,26.145952207534588,495032.07860000001,144966.73461000001,29.284311234936606,66014.00774999999,100,144866.97991999998,100,97.913139999999999,0.14832176281555942,37937.429999999993,144966.73461000001,200]
["$ indicates as on June 30, 2017"]
["Source: NSE."]

{"sheet":"30","index":30,"n_rows":15,"n_cols":18,"rows_kept":15,"cut":false,"hidden":false,"merged":[[10,0,10,5],[1,14,2,15],[1,16,2,17],[2,6,2,7],[2,8,2,9],[2,10,2,11],[2,12,2,13],[1,0,3,0],[1,1,3,1],[1,2,2,3],[1,4,2,5],[1,6,1,9],[1,10,1,13]]}
["Table 30: Trends in Equity Derivatives Segment at BSE (Turnover in Notional Value) "]
["Year/     Month\n","No. of Trading Days","Index Futures",null,"Stock Futures",null,"Index Options",null,null,null,"Stock Options",null,null,null,"Total",null,"Open Interest at the end of month"]
[null,null,null,null,null,null,"Call",null,"Put",null,"Call",null,"Put"]
[null,null,"No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Value      (` crore)"]
["2016-17",248,32288,2266.9588757499996,2901,203.0703815,24433,1254.8940116000001,63916,3214.4509813,0,0,0,0,123538,6939.374250150001,107,7.71]
["2017-18",61,39676,2878.7708081250003,163,13.165557750000001,82,5.9207460000000003,32,2.284462875,0,0,0,0,39953,2900.14157475,66,5]
["2017-04-04",18,18597,1330.182556875,51,4.3414582500000005,82,5.9207460000000003,32,2.284462875,0,0,0,0,18762,1342.7292239999999,91,6.52]
["2017-05-04",22,14812,1080.579984,69,5.4005650000000003,0,0,0,0,0,0,0,0,14881,1085.9805490000001,281,21.06]
["2017-06-04",21,6267,468.00826725000002,43,3.4235345000000006,0,0,0,0,0,0,0,0,6310,471.43180175000003,66,5]
["Note: 1. Notional Turnover = (Strike Price + Premium) * Quantity."]
["$ indicates as on June 30, 2017"]
["Source: BSE."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"31","index":31,"n_rows":12,"n_cols":18,"rows_kept":12,"cut":false,"hidden":false,"merged":[[10,0,10,5],[1,14,2,15],[1,16,2,17],[2,6,2,7],[2,8,2,9],[2,10,2,11],[2,12,2,13],[0,0,0,12],[1,0,3,0],[1,1,3,1],[1,2,2,3],[1,4,2,5],[1,6,1,9],[1,10,1,13]]}
["Table 31: Trends in Equity Derivatives Segment at NSE (Turnover in Notional Value) "]
["Year/     Month\n","No. of Trading Days","Index Futures",null,"Stock Futures",null,"Index Options",null,null,null,"Stock Options",null,null,null,"Total",null,"Open Interest at the end of month"]
[null,null,null,null,null,null,"Call",null,"Put",null,"Call",null,"Put"]
[null,null,"No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Value   (` crore)"]
["2016-17",248,66535071,4335940.8669368746,173860130,11129587.189949306,548735127,38097964.384784557,518509789,34699323.311763808,61205774,4147487.9247215153,30900238,1959997.9397227899,1399746129,94370301.617878839,3542404,249497.47536044996]
["2017-18$",61,13042565,1012672.318601625,50766264,3673192.1005516052,157704633,13210650.426166775,156644963,12705495.729067201,19251257,1492772.40217747,9293719,678568.25605008495,406703401,32773351.23661476,3687855,263318.85699867504]
["2017-04-14",18,4174077,314579.89140094997,15323013,1160682.4806404901,46181751,3729736.0531744501,45548822,3554410.9430585499,6024771,487146.94306098,2823557,213125.24269360999,120075991,9459681.5540290307,3718137,263898.84912227001]
["2017-05-17",22,4816269,375948.83030067501,19724492,1402147.8829111154,55223511,4617328.2359923245,57343652,4630977.84000865,7598657,580166.66911648994,3814715,274832.924256475,148521296,11881402.382585727,4312372,312587.69447087502]
["2017-06-17",21,4052219,322143.5969,15718759,1110361.737,56299371,4863586.1370000001,53752489,4520106.9460000005,5627829,425458.79,2655447,190610.08910000001,138106114,11432267.300000001,3687855,263318.85699867504]
["Note: 1. Notional Turnover = (Strike Price + Premium) * Quantity."]
["$ indicates as on June 30, 2017"]
["Source: NSE."]

{"sheet":"32","index":32,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,11,3,11],[2,12,3,12],[9,0,9,5],[0,0,0,12],[1,0,3,0],[1,1,1,6],[1,7,1,12],[2,1,2,2],[2,3,2,4],[2,5,3,5],[2,6,3,6],[2,7,2,8],[2,9,2,10]]}
["Table 32: Settlement Statistics in Equity Derivatives Segment at BSE and NSE (` crore)"]
["Year/     Month\n","BSE",null,null,null,null,null,"NSE"]
[null,"Index/Stock Futures",null,"Index/Stock Options",null," Total","Settlement Gurantee Fund","Index/Stock Futures",null,"Index/Stock Options",null," Total","Settlement Gurantee Fund"]
[null,"MTM Settlement","Final Settlement","Premium Settlement","Exercise Settlement",null,null,"MTM Settlement","Final Settlement","Premium Settlement","Exercise Settlement"]
["2016-17",15.099999999999998,1.1100000000000001,33.380000000000003,0.01,49.599999999999994,192.09000000000003,70441.81,2049.23,15021.649999999998,2579.88,90092.569999999992,1051.99]
["2017-18$",7.2,0.23,0.05,0,7.48,16.95,20846.22,618.72,3847.39,844.45,26156.78,1146.3800000000001]
["2017-04-04",2.08,0.04,0.05,0.01,2.17,16.73,5356.92,79.83,1278.31,244.02,6959.08,1100.3499999999999]
["2017-05-04",2.41,7.0000000000000007E-2,0.05,0,2.48,16.84,10259.5,394.85,1239.48,192.7,12086.53,1132.6300000000001]
["2017-06-04",2.71,0.12,0.05,0,2.83,16.95,5229.8,144.04,1329.6,407.73,7111.17,1146.3800000000001]
["$ indicates as on June 30, 2017"]
["Source: BSE and NSE"]

{"sheet":"33","index":33,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,5],[1,6,1,10],[8,0,8,5]]}
["Table 33: Category-wise Share of Turnover & Open Interest in Equity Derivative Segment of BSE"]
["Month","Percentage Share in Turnover",null,null,null,null,"Percentage Share in Open Interest"]
[null,"Pro","FII","Mutual Funds","Banks","Others","Pro","FII","Mutual Funds","Banks","Others"]
["2016-17",72.461825779561678,0,0,0,27.538174220438322,65.887850467289724,0,0,0,34.112149532710276]
["2017-18$",93.042314491840145,1.4075539076404882,0,0,5.550131600519367,45.55,0,0,0,54.45]
["2017-04-04",94.939047414745176,0.17647414181848475,0,0,4.8844784434363397,91.03,0,0,0,8.9700000000000006]
["2017-05-04",95.742584969171503,0,0,0,4.257415030828497,94.330799999999996,0,0,0,5.6692]
["2017-06-04",81.419763953694712,8.1563199692435688,0,0,10.423916077061719,45.55,0,0,0,54.45]
["$ indicates as on June 30, 2017"]
["Source: BSE."]

{"sheet":"34","index":34,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,5],[1,6,1,10],[8,0,8,5]]}
["Table 34: Category-wise Share of Turnover & Open Interest in Equity Derivative Segment of NSE"]
["Month","Percentage Share in Turnover",null,null,null,null,"Percentage Share in Open Interest"]
[null,"Pro","FII","Mutual Funds","Banks","Others","Pro","FII","Mutual Funds","Banks","Others"]
["2016-17",42.06696663713263,13.747339229662797,0.40370141801453302,0,43.783686257126277,13.240150824172201,31.2372138347895,8.679193191740179,0,46.843442149298099]
["2017-18$",41.6,11.15,0.42,0,46.83,13.707375617364461,27.423265671580275,9.7203549815149941,0,49.148325828517073]
["2017-04-01",41.723667672142902,10.820978788187899,0.47758335216789599,0,46.977770187501299,14.317806018929916,26.239478598953887,9.2371419442430298,0,50.205573437873177]
["2017-05-17",41.392811719015597,11.8357790833298,0.39501575080018902,0,46.376393446854401,15.442071723180623,26.192490605227313,8.714404591533917,0,49.650383785348737]
["2017-07-02",41.711595789950003,10.7014193387795,0.40975063876624002,0,47.18,13.707375617364461,27.423265671580275,9.7203549815149941,0,49.148325828517073]
["$ indicates as on June 30, 2017"]
["Source: NSE."]

{"sheet":"35","index":35,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,9],[8,0,8,5]]}
["Table 35: Instrument-wise Turnover in Index Derivatives at BSE"]
["Month","Turnover (in Percentage)"]
[null,"BSE 30 SENSEX                 ","BSE BANKEX                    ","BSE OIL & GAS INDEX           ","BSE TECK INDEX                ","BSE100","HANG SENG Index Futures","MICEX Index Futures","FTSE/JSE Top 40 Futures","IBOVESPA Futures"]
["2016-17",3.3196912076773013,0,0,0,5.8662362269730702E-5,5.6351377164948809E-3,0,0,0]
["2017-18$",0,0,0,0,0,5.8662362269730702E-5,0,0,0]
["2017-04-04",0,0,0,0,0,5.8662362269730702E-5,0,0,0]
["2017-05-05",0,0,0,0,0,5.8662362269730702E-5,0,0,0]
["2017-06-05",0,0,0,0,0,5.8662362269730702E-5,0,0,0]
["$ indicates as on June 30, 2017"]
["Source: BSE."]

{"sheet":"36","index":36,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,10],[8,0,8,5]]}
["Table 36: Instrument-wise Turnover in Index Derivatives at NSE"]
["Month","Turnover (in Percentage)"]
[null,"NIFTY","CNXIT","BANKNIFTY","NFTYMCAP50","CNXPSE","CNXINFRA","FTSE100","S&P500","DJIA","India VIX"]
["2016-17",54.466014224134859,5.0275883629818828E-3,45.518386628221926,1.5248629182323644E-6,6.9786006630976451E-7,1.419005168569006E-6,2.8102577065290374E-6,5.7007381392454939E-3,4.1124110666380673E-3,1.9157077912717019E-5]
["2017-18$",34.450000000000003,4.9894776819678858E-3,65.540000000000006,0,0,1.2354808137902924E-5,0,4.6337317670286328E-3,1.6803027433482439E-3,0]
["2017-04-16",38.237174446253988,5.056146400329844E-3,61.749785708921969,0,0,0,0,4.1603177206495853E-3,2.9467418136108507E-3,0]
["2017-05-17",38.762154819752283,4.3788485872715234E-3,61.226598585986281,0,9.5275946961837472E-6,0,0,4.4514284266253864E-3,2.2645140545612345E-3,0]
["2017-06-17",34.450000000000003,4.9894776819678858E-3,65.540000000000006,0,0,1.2354808137902924E-5,0,4.6337317670286328E-3,1.6803027433482439E-3,0]
["$ indicates as on June 30, 2017"]
["Source: NSE."]

{"sheet":"37","index":37,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,0,9,11],[10,0,10,5],[0,0,0,11],[1,0,3,0],[1,2,1,3],[1,4,1,7],[1,8,1,9],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,2,5],[2,6,2,7],[2,8,3,8],[2,9,3,9],[2,10,2,11]]}
["Table 37: Trends in Currency Derivatives Segment at NSE"]
["Year/     Month\n",null,"Currency Futures",null,"Currency Options",null,null,null,"Total"]
[null,"No. of Trading  Days","No. of Contracts ","Turnover (` crore)","Call",null,"Put",null,"No. of Contracts ","Turnover (` crore)","Open Interest at the end of"]
[null,null,null,"Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)",null,null,"No. of Contracts "," Value\n(` crore)"]
["2016-17",242,362615931,2489778.9357585004,205484781,1396641.0541205001,144350727,970655.86492399999,712451439,4857075.8548030006,4734914,30871.429250000001]
["2017-18$",60,80257550,529753.01669724996,51476175,336175.33532300004,38618366,249930.01960699999,170352091,1115858.37162725,3881086,25366.881690000002]
["2017-04-14",18,27621713,181185.62938574998,18853378,123279.42861924999,14430861,93539.269776749992,60905952,398004.32778175006,4675628,30260.306960000002]
["2017-05-17",21,27752227,182960.46474874998,17856365,116543.03489525002,14483328,93619.011668250008,60091920,393122.51131224993,4430643,28809.461889999999]
["2017-06-17",21,24883610,165606.92256275,14766432,96352.871808500015,9704177,62771.738161999987,49354219,324731.53253324999,3881086,25366.881690000002]
["Notes: 1. Trading Value :- For Futures, Value of contract = Traded Qty*Traded Price. 2. For Options, Value of contract = Traded Qty*(Strike Price+Traded Premium)"]
["$ indicates as on June 30, 2017"]
["Source: NSE."]

{"sheet":"38","index":38,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,0,9,3],[0,0,0,11],[1,0,3,0],[1,1,3,1],[1,2,2,3],[1,4,1,7],[1,8,2,9],[1,10,2,11],[2,4,2,5],[2,6,2,7]]}
["Table 38: Trends in Currency Derivatives Segment at MSEI"]
["Year/     Month\n","No. of Trading Days","Currency Futures",null,"Currency Options",null,null,null,"Total",null,"Open Interest at the end of "]
[null,null,null,null,"Call",null,"Put"]
[null,null,"No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Value \n(` crore)"]
["2016-17",242,42223837,285472.84277700004,954966,6432.813286749999,877609,6022.0180270000001,44056412,297927.67409075005,232589,1518.3514342500041]
["2017-18$",60,5446073,35270.721736499996,232506,1518.1979145,178425,1165.7697695000002,5857004,37954.689420499999,225653,1475.5876867499996]
["2017-04-01",18,1471757,9535.4690749999991,57763,377.98408524999996,39504,256.34527350000002,1569024,10169.798433749998,231735,1503.5669052499998]
["2017-05-01",21,1992752,12902.942646249998,51486,338.25196874999995,51822,341.15406075000004,2096060,13582.348675749998,292390,1906.2135549999998]
["2017-06-01",21,1981564,12832.310015249999,123257,801.96186050000017,87099,568.27043524999999,2191920,14202.542310999999,225653,1475.5876867499996]
["$ indicates as on June 30, 2017"]
["Source: MSEI"]

{"sheet":"39","index":39,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,0,9,5],[10,0,10,5],[0,0,0,11],[1,0,3,0],[1,1,3,1],[1,2,2,3],[1,4,1,7],[1,8,2,9],[1,10,2,11],[2,4,2,5],[2,6,2,7]]}
["Table 39: Trends in Currency Derivatives Segment at BSE"]
["Year/     Month\n","No. of Trading Days","Currency Futures",null,"Currency  Options",null,null,null,"Total",null,"Open Interest at the end of "]
[null,null,null,null,"Call",null,"Put"]
[null,null,"No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Value \n(` crore)"]
["2016-17",242,268339687,1807828.5310000002,111541346,758231.27079999994,90544169,605588.13560000004,470425202,3171647.9373999992,1598346,10381.870000000001]
["2017-18$",60,62781438,406829.77870000008,53878191,353228.02020000003,51260291,328809.43680000002,167919920,1088867.2357000001,1038281,6741.29]
["2017-04-04",18,20518735,132905.016,17411265,114292.99850000002,14234398,91523.090500000006,52164398,338721.10500000004,1456658,9363.429339575001]
["2017-05-04",21,22099454,143176.72040000005,18403355,120531.74100000001,19125359,122579.47230000001,59628168,386287.93370000005,1396753,9023.0499999999993]
["2017-06-04",21,20163249,130748.04230000003,18063571,118403.2807,17900534,114706.87399999998,56127354,363858.19699999999,1038281,6741.29]
["$ indicates as on June 30, 2017"]
["Source: BSE"]

{"sheet":"40","index":40,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[[10,0,10,5],[1,15,4,15],[2,1,2,2],[2,3,2,4],[2,6,2,7],[2,8,2,9],[2,11,2,12],[2,13,2,14],[3,1,4,1],[3,2,4,2],[3,3,4,3],[1,0,4,0],[1,1,1,4],[1,5,4,5],[1,6,1,9],[1,10,4,10],[1,11,1,14],[3,4,4,4],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,11,4,11],[3,12,4,12],[3,13,4,13],[3,14,4,14]]}
["Table 40: Settlement Statistics of Currency Derivatives Segment (` crore)"]
["Year/     Month\n","NSE",null,null,null,"Total","MSEI",null,null,null,"Total","BSE",null,null,null,"Total"]
[null,"Currency Futures",null,"Currency Options",null,"Total","Currency Futures",null,"Currency options",null,"Total","Currency Futures",null,"Currency Options",null,"Total"]
[null,"MTM Settlement","Final Settlement","Premium Settlement","Exercise Settlement",null,"MTM Settlement","Final Settlement","Premium Settlement","Exercise Settlement",null,"MTM Settlement","Final Settlement","Premium Settlement","Exercise Settlement"]
[null,null,null,null,"Exercise Settlement",null,null,null,null,"Exercise Settlement",null,null,null,null,"Exercise Settlement"]
["2016-17",5131.6970127500008,193.09517621999998,1098.3142855000001,451.13654268000005,6874.24301715,562.17096175000006,19.354808000000002,14.611617500000001,9.3295554500000009,605.4669427,3594.2999999999993,105.16,2896.64,223.14,6819.2399999999989]
["2017-18$",897.46745874999999,21.469706479999999,286.49598550000002,126.79594193999999,1332.22909267,106.80764000000001,3.4239999999999999,3.91,1.31,115.45164,820.23,21.529999999999998,1247.3800000000001,58.37,2147.5099999999998]
["2017-04-14",330.323578,16.768680029999999,122.5572205,73.557515039999998,543.20699357000001,39.937640000000002,2.83,1.54,0.53,44.83764,318.99,16.059999999999999,407.52,39.049999999999997,781.62]
["2017-05-01",417.36388075000002,3.2710264499999999,95.928764999999999,35.328426899999997,551.8920991,49.85,0.54,1.7,0.56999999999999995,52.660000000000004,353.53,4.6399999999999997,494.94,10.58,863.69]
["2017-06-17",149.78,1.43,68.010000000000005,17.91,237.13000000000002,17.02,5.3999999999999999E-2,0.67,0.21,17.954000000000001,147.71,0.83,344.92,8.74,502.2]
["$ indicates as on June 30, 2017"]
["Source: Respective stock exchanges"]

{"sheet":"41","index":41,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,4],[1,5,1,8]]}
["Table 41: Instrument-wise Turnover in Currency Derivatives of NSE"]
["Month","Turnover (in ₹ crore)",null,null,null,"Open Interest as on last day of the month\n(in lots)"]
[null,"USDINR","EURINR","GBPINR","JPYINR","USDINR","EURINR","GBPINR","JPYINR"]
["2016-17",4507897.7881492507,99183.968137249991,183698.5956185,66295.502898000006,4606551,67631,43717,17015]
["2017-18$",1034198.436088,28626.514910500002,42275.096584500003,10758.324044249999,3684399,117120,56481,23086]
["2017-04-16",375224.38652725,8047.3024497500001,11271.904839500001,3460.73396525,4514665,94594,48928,17441]
["2017-05-17",366872.0968155,10063.13913675,12755.4962275,3431.7791324999998,4285462,82866,47918,14397]
["2017-06-17",292101.95274525002,10516.073324000001,18247.6955175,3865.8109464999998,3684399,117120,56481,23086]
["$ indicates as on June 30, 2017"]
["Source: NSE."]

{"sheet":"42","index":42,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,4],[1,5,1,8]]}
["Table 42: Instrument-wise Turnover in Currency Derivative Segment of MSEI"]
["Month","Turnover\n(₹ crore)",null,null,null,"Open Interest as on last day of the month\n(in lots)"]
[null,"USDINR","EURINR","GBPINR","JPYINR","USDINR","EURINR","GBPINR","JPYINR"]
["2016-17",289589.36888000008,2173.1384129999992,4391.6644955000002,1773.4907787500001,226074,1546,3268,1701]
["2017-18$",37433.97320925002,168.48736600000001,283.21023025,69.018635999999987,223861,607,970,215]
["2017-04-30",9917.6243712500145,106.76672000000003,118.25748374999996,27.149858749999996,228201,138,2794,602]
["2017-05-30",13432.294951999995,33.952947999999978,90.845741500000045,25.255034249999984,291263,128,900,99]
["2017-06-30",14084.053886000009,27.767697999999992,74.107005000000015,16.613742999999999,223861,607,970,215]
["$ indicates as on June 30, 2017"]
["Source: MSEI"]

{"sheet":"43","index":43,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,4],[1,5,1,8]]}
["Table 43: Instrument-wise Turnover in Currency Derivative Segment of BSE"]
["Month","Turnover\n(₹ crore)",null,null,null,"Open Interest as on last day of the month\n(in lots)"]
[null,"USDINR","EURINR","GBPINR","JPYINR","USDINR","EURINR","GBPINR","JPYINR"]
["2016-17",3148260.1672999999,9756.0034999999989,9401.1265999999996,4230.6399999999994,1575230,11810,9156,2150]
["2017-18$",1081684.4018000001,2605.9447,4111.4733999999999,465.41579999999999,1022494,8718,6242,827]
["2017-04-13",336519.95020000002,667.48299999999995,1295.1177,238.55410000000001,1445427,6993,2533,1705]
["2017-05-14",384078.53600000008,887.19420000000014,1208.2427,113.96080000000002,1389505,4175,2603,470]
["2017-06-14",361085.91560000001,1051.2674999999999,1608.1129999999998,112.90089999999999,1022494,8718,6242,827]
["$ indicates as on June 30, 2017"]
["Source: BSE"]

{"sheet":"44","index":44,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,4],[1,5,1,8]]}
["Table 44: Maturity-wise Turnover in Currency Derivative Segment of NSE  (₹ crore)"]
["Month","Currency Futures",null,null,null,"Currency Options"]
[null,"1 Month","2 Month","3 Month","> 3 months","1 Month","2 Month","3 Month","> 3 months"]
["2016-17",1999419.57419375,429520.32765399996,40831.977613499999,20007.056297250001,1954971.52651975,398290.24093924992,13984.87507075,50.276514750000011]
["2017-18$",403723.44382525003,108900.32367124999,12117.10205625,5012.1471444999997,474481.24239050003,109322.08205899999,2212.1102667499999,89.920213750000002]
["2017-04-16",135414.65723225003,39230.801059750003,4754.7426537499996,1785.4284399999995,178366.66516450001,38198.920673499997,252.0210635,1.0914945]
["2017-05-16",138347.51354499999,39046.828908750002,3944.5495917499998,1621.5727032499999,167617.77818875,41422.297188750003,1118.7855462499999,3.1856397500000004]
["2017-06-17",129961.27304799999,30622.693702750003,3417.8098107500005,1605.1460012500002,128496.79903724999,29700.864196749997,841.30365699999993,85.643079499999999]
["$ indicates as on June 30, 2017"]
["Source: NSE."]

{"sheet":"45","index":45,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,4],[1,5,1,8]]}
["Table 45: Maturity-wise Turnover in Currency Derivative Segment of MSEI (₹ crore)"]
["Month","Currency Futures",null,null,null,"Currency Options"]
[null,"1 Month","2 Month","3 Month","> 3 months","1 Month","2 Month","3 Month","> 3 months"]
["2016-17",231099.26483950001,52784.177152999997,1532.0660904999997,57.339073499999998,12098.319521999998,344.85279349999996,11.6629,0]
["2017-18$",25885.083620500001,8191.9322455000001,1184.2620660000002,9.4437715000000004,1798.2461640000001,375.75651749999997,509.96500000000003,0]
["2016-04-30",7054.8388064999999,2209.6342040000004,270.98950950000005,6.5399999999999998E-3,527.17367400000001,60.101684000000006,47.054000000000002,0]
["2017-05-30",9551.7125330000017,3207.0152425000001,144.01786300000001,0.19699,118.745901,124.43712699999999,436.22300000000001,0]
["2017-06-30",9278.5322809999998,2775.2827990000001,769.25469350000003,9.2402414999999998,1152.326589,191.21770649999999,26.687999999999999,0]
["$ indicates as on June 30, 2017"]
["Source: MSEI"]

{"sheet":"46","index":46,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,4],[1,5,1,8]]}
["Table 46: Maturity-wise Turnover in Currency Derivative Segment of BSE (₹ crore)"]
["Month","Currency Futures",null,null,null,"Currency Options"]
[null,"1 Month","2 Month","3 Month","> 3 months","1 Month","2 Month","3 Month","> 3 months"]
["2016-17",1570858.1343702502,222641.9086735,13202.433876000003,1118.434679,1221761.1903335,137286.83551825001,4461.4851657500003,309.19624999999996]
["2017-18$",414171.89999999997,61256.939999999988,3720.4000000000005,590.56999999999994,521266.66999999993,85169.919999999998,2150.16,538.20999999999992]
["2017-04-04",180181.69,25587.919999999995,42.36,4.8699999999999992,110665.26999999999,19729.88,1995.4799999999998,513.61]
["2017-05-04",122794.77999999997,18298.559999999994,1764.56,317.93999999999994,199364.43999999997,43611.35,123.80000000000001,11.3]
["2017-06-04",111195.43,17370.46,1913.4800000000005,267.76,211236.96,21828.69,30.88,13.299999999999999]
["$ indicates as on June 30, 2017"]
["Source: BSE"]

{"sheet":"47","index":47,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[4,11,5,11],[4,12,5,12],[4,13,5,13],[11,0,11,5],[2,12,3,13],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[1,0,5,0],[1,1,5,1],[1,2,1,5],[1,6,1,9],[1,10,1,13],[2,2,3,3],[2,4,3,5],[2,6,3,7],[2,8,3,9],[2,10,3,11]]}
["Table 47: Trading Statistics of Interest Rate Futures at BSE, NSE and MSEI"]
["Year/ Month\n","No. of Trading Days","BSE",null,null,null,"NSE",null,null,null,"MSEI"]
[null,null,"Interest RateFutures",null,"Open Interest at the end of ",null,"Interest RateFutures",null,"Open Interest at the end of ",null,"Interest RateFutures",null,"Open Interest at the end of                        "]
[]
[null,null,"No. of Contracts ","Traded Value \n(₹ crore)","No. of Contracts "," Value \n(₹ crore)","No. of Contracts ","Traded Value \n(₹ crore)","No. of Contracts "," Value \n(₹ crore)","No. of Contracts ","Traded Value \n(₹ crore)","No. of Contracts "," Value \n(₹ crore)"]
[]
["2016-17",242,6185341,127979.4124,18044,377.6807,14807039,307809.32010699995,120422,2482.4497529999999,125175.49764749999,2551.8521309999992,0,0]
["2017-18$",60,2032830,41933.998800000001,5410,111.79040000000001,3976904,81884.586587999991,87169,1797.4729609999999,0,0,0,0]
["2017-04-04",18,534693,11046.7248,13550,279.0231,1596049,32824.362904999994,88000,1803.5133559999999,0,0,0,0]
["2017-05-04",21,595544,12230.2824,4158,84.726600000000005,1082509,22208.391542499998,91173,1871.2867900000001,0,0,0,0]
["2017-06-04",21,902593,18656.991600000001,5410,111.79040000000001,1298346,26851.832140500006,87169,1797.4729609999999,0,0,0,0]
["$ indicates as on June 30, 2017"]
["Source: BSE, NSE and MSEI"]

{"sheet":"48","index":48,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[8,0,8,4],[0,0,0,8],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6]]}
["Table 48: Settlement Statistics in Interest Rate Futures at BSE, NSE and MSEI (₹   crore)"]
["Year/ Month","BSE",null,"NSE",null,"MSEI"]
[null,"MTM Settlement","Physical Delivery Settlement","MTM Settlement","Physical Delivery Settlement","MTM Settlement","Physical Delivery Settlement"]
["2016-17",101.69984199999999,8.3763419999999993,1128.3717025000001,41.862663360000006,10.030167,0]
["2017-18$",58.579379000000003,2.3244400000000001,197.69042049999999,5.3094264400000002,0,0]
["2017-04-04",24.581016000000002,1.24733,75.886161999999999,1.7786042400000002,0,0]
["2017-05-04",22.984908999999998,0.93076099999999995,65.144258500000007,2.0008222,0,0]
["2017-06-04",11.013453999999999,0.14634900000000001,56.66,1.53,0,0]
["$ indicates as on June 30, 2017"]
["Source: NSE, BSE and MSEI"]

{"sheet":"49","index":49,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,5],[7,0,7,5],[8,0,8,5]]}
["Table 49: Trends in Foreign Portfolio Investment"]
["Year/Month","Gross Purchase (₹ crore)","Gross Sales (₹ crore)","Net Investment\n (₹ crore)","Net Investment \n(US $ mn.)","Cumulative Net\n Investment       (US $ mn.)"]
["2016-17",1507027.6999999997,1458616.67,48411.03,7599.6499999999978,231187.34999999998]
["2017-18$",439292.02999999997,360365.7,78926.33,12231.470000000001,243418.81999999998]
["2017-04-01",121630.47,98872.23,22758.240000000002,3513.38,234700.72999999998]
["2017-05-01",148177.26,121311.1,26866.16,4169.96,238870.68999999997]
["2017-06-01",169484.3,140182.37,29301.93,4548.13,243418.81999999998]
["$ indicates as on June 30, 2017"]
["Source: NSDL, CDSL"]

{"sheet":"50","index":50,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,7],[7,0,7,8],[8,0,8,5],[9,0,9,1]]}
["Table 50: Notional Value of Offshore Derivative Instruments (ODIs) Vs Assets Under Custody (AUC) of FPIs/Deemed FPIs (₹ crore)"]
["Year/ Month","Notional value of ODIs on Equity, Debt & Derivatives ","Notional value of ODIs on Equity & Debt  excluding Derivatives ","Assets Under Custody of FPIs/Deemed FPIs","Notional value of ODIs on Equity, Debt & Derivatives as % of  Assets Under Custody of FPIs/Deemed FPIs","Notional value of ODIs on Equity & Debt  excluding Derivatives as % of  Assets Under Custody of FPIs/Deemed FPIs"]
["2016-17",178437,124277,2705729,6.6,4.5999999999999996]
["2017-18$",165241,132785,2883104,5.7,4.5999999999999996]
["2017-04-01",168545,128380,2786083,6,4.5999999999999996]
["2017-05-01",180718,133045,2856637,6.3,4.7]
["2017-06-01",165241,132785,2883104,5.7,4.5999999999999996]
["Notes: 1. Figures are compiled based on reports submitted by FPIs/deemed FPIs issuing ODIs. 2. Column 4 Figures are compiled on the basis of reports submitted by custodians & does not includes positions taken by FPIs/deemed FPIs in derivatives. 3. The total value of ODIs excludes the unhedged positions & portfolio hedging positions taken by the FPIs/deemed FPIs issuing ODIs.\n"]
["$ indicates as on June 30, 2017"]
["Source: SEBI."]

{"sheet":"51","index":51,"n_rows":12,"n_cols":29,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,27,1,28],[8,0,8,24],[9,0,9,14],[1,11,1,12],[1,13,1,14],[1,15,1,16],[1,17,1,18],[1,19,1,20],[1,21,1,22],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[11,0,11,9],[10,0,10,5],[1,23,1,24],[1,25,1,26]]}
["Table 51: Assets under the Custody of Custodians"]
["       Client\n\nPeriod","FPIs ",null,"Foreign Depositories",null,"FDI Investments",null,"Foreign Venture Capital Investments",null,"OCBs",null,"NRIs",null,"Mutual Funds",null,"Corporates",null,"Banks",null,"Insurance Companies",null,"Local Pension Funds",null,"Financial Institutions ",null,"Others",null,"Total"]
[null,"No.","Amount (₹ crore)","No.","Amount (₹ crore)","No.","Amount (₹ crore)","No.","Amount (₹ crore)","No.","Amount (₹ crore)","No.","Amount (₹ crore)","No.","Amount (₹ crore)","No.","Amount (₹ crore)","No.","Amount (₹ crore)","No.","Amount (₹ crore)","No.","Amount (₹ crore)","No.","Amount (₹ crore)","No.","Amount (₹ crore)","No.","Amount (₹ crore)"]
["2016-17",8956,2705728.63,64,272829.5,1532,591977.26,188,31695.23,22,2174.73,330,2848.76,1663,1536949.49,434,73926.820000000007,115,303380.12,766,1440522.63,96,227369.36,29,74173.72,11320,543186.91,25515,7806763.1600000011]
["2017-18$",8914,2882134.3844740558,63,284149.147133825,1566,602120.93098626996,190,31645.947601938002,22,2156.9049999999997,332,2892.83,1553,1619245.8139020971,451,79201.014539536001,111,307084.2929582402,783,1482775.6327685358,114,277223.42033403,29,77531.260000000009,12401,569590.06645669253,26529,8217751.6461552205]
["2017-04-30",8884,2786082.88,63,273675.52000000002,1541,587640.11,190,31661.56,22,2187.2600000000002,334,2943.76,1646,1664012.38,436,76733.59,110,307675.34999999998,774,1468849.19,115,228105.69,29,75704.039999999994,11603,551698.93999999994,25747,8056970.2699999996]
["2017-05-31",8750,2856637.1841731947,63,287842.98290442297,1547,599259.542611251,189,31595.513451170002,22,2226.6949999999997,331,2847.27,1634,1656901.779023227,444,78055.547747981793,111,308179.84508516855,779,1479654.6773251793,114,245604.47430989999,29,79189.47,11901,557451.03054821538,25914,8185446.01217971]
["2017-06-30",8914,2882134.3844740558,63,284149.147133825,1566,602120.93098626996,190,31645.947601938002,22,2156.9049999999997,332,2892.83,1553,1619245.8139020971,451,79201.014539536001,111,307084.2929582402,783,1482775.6327685358,114,277223.42033403,29,77531.260000000009,12401,569590.06645669253,26529,8217751.6461552205]
["Notes: 1. With the commencement of FPI Regime from June 1, 2014, the erstwhile FIIs, Sub Accounts and QFIs are merged into a new investor class termed as “Foreign Portfolio Investors (FPIs)”. "]
["2. \"Others\" include Portfolio manager, partnership firm, trusts, depository receipts, AIFs, FCCB, HUFs, Brokers etc."]
["$ indicates as on June 30, 2017"]
["Source: Custodians."]

{"sheet":"52","index":52,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[8,0,8,4],[0,0,0,10],[1,0,2,0],[1,1,1,3],[1,4,1,6],[1,7,1,9],[1,10,2,10]]}
["Table 52: Trends in Resource Mobilization by Mutual Funds (₹ crore)"]
["Year/ Month","Gross Mobilisation",null,null,"Redemption",null,null,"Net Inflow/Outflow",null,null,"Assets at the\n End of Period"]
[null,"Pvt. \nSector","Public\n Sector","Total ","Pvt.\n Sector","Public\n Sector","Total ","Pvt. \nSector","Public\n Sector","Total"]
["2016-17",14247937.300589059,3367611.5593166081,17615548.859905668,13968549.079247728,3303950.8791615008,17272499.958409227,279388.22134133097,63660.680155106704,343048.90149643773,1754619.0824741903]
["2017-18$",3986649.0634158123,862397.55632458581,4849046.6197403977,3913948.722324647,841698.38031581894,4755647.1026404658,72700.341091166658,20699.176008766815,93399.51709993348,1896290.7199531868]
["2017-04-30",1361008.4115072591,276212.03437680303,1637220.4458840622,1233420.2673160513,253097.02207348909,1486517.2893895404,127588.14419120742,23115.01230331395,150703.15649452136,1926302.2825962843]
["2017-05-31",1358637.8850530759,300816.66345464572,1659454.5485077214,1399131.860554893,301033.74546349788,1700165.606018391,-40493.975501817273,-217.08200885221595,-40711.057510669474,1903975.4048693876]
["2017-06-30",1267002.7668554774,285368.85849313706,1552371.6253486141,1281396.5944537027,287567.61277883197,1568964.2072325344,-14393.827598223492,-2198.7542856949185,-16592.581883918407,1896290.7199531868]
["$ indicates as on June 30, 2017"]
["Source: SEBI."]
[]
[]
[]
[]
[null,null,null,null,null,"`"]

{"sheet":"53","index":53,"n_rows":9,"n_cols":16,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,2,0],[1,1,1,3],[1,4,1,6],[1,7,1,9],[1,10,2,10]]}
["Table 53: Type-wise Resource Mobilisation by Mutual Funds: Open-ended and Close-ended (₹ crore)"]
["Scheme","2016-17",null,null,"2017-18$",null,null,"Jul-17",null,null,"Assets at the end of period\n"]
[null,"Sale","Purchase","Net","Sale","Purchase","Net","Sale","Purchase","Net",null,null,null,"Sale","Purchase","Net"]
["Open-ended",17229415.456679244,17587220.525383148,357805.06870390155,7882161.6414063061,8127480.8679673197,245319.22656101274,4721166.0051296223,4838174.797199728,117008.79207010516,1735184.5030800162,null,null,15184479.492485318,15601374.00589087,416894.51340555213]
["Close-ended",39079.684936704427,28028.804206286004,-11050.880730418427,58974.817705684167,18236.458711711999,-40738.358993972171,33742.502709246932,10869.577957130001,-22872.924752116931,157190.25317810962,null,null,36891.8274762047,21155.677579988002,-15736.149896216701]
["Interval",4004.81350561106,299.53022720868552,-3705.2832784023744,1193.5389364053003,4.2874531493282602,-1189.2514832559721,738.594801596102,2.2445835396641303,-736.35021805643782,3915.9636950605704,null,null,3521.7123961043494,295.18843294674673,-3226.5239631576028]
["Total",17272499.955121562,17615548.859816644,343048.90469508077,7942329.9980483958,8145721.6141321808,203391.61608378461,4755647.1026404658,4849046.6197403977,93399.517099931792,1896290.7199531863,null,null,15224893.032357628,15622824.871903805,397931.83954617783]
["$ indicates as on June 30, 2017"]
["Source: SEBI."]

{"sheet":"54","index":54,"n_rows":20,"n_cols":17,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,14,1,16],[18,0,18,1],[0,0,0,11],[1,0,2,0],[1,1,1,4],[1,5,1,7],[1,9,1,11]]}
["Table 54: Scheme-wise Resource Mobilisation and Assets under Management by Mutual Funds (₹ crore)"]
["Type ","2016-17",null,null,null,"2017-18$",null,null,null,"Jul-17",null,null,null,null,"Upto Jan 17"]
[null,"Sale","Purchase","Net","Assets at the end of Period","Sale","Purchase","Net","Assets at the end of Period","Sale","Purchase","Net",null,null,"Sale","Purchase","Net"]
["A. Income/Debt Oriented Schemes \n     (i+ii+iii+iv)",17090456.110409692,17303610.259073593,213154.14866389823,1074652.0310916372,4703837.7338367021,4744573.1495171357,40735.415680432896,1140204.9239949784,1547935.9261802402,1514476.2784275091,-33459.647752731194,null,null,15070850.586571293,15356527.836868433,285677.25029714033]
["    i. Liquid/Money Market",16327426.646422146,16423252.865481094,95826.219058947638,314085.89059123897,4474881.607740093,4496853.6941920007,21972.086451907642,344923.47117796034,1452312.5052389018,1439573.952049782,-12738.55318911979,null,null,14453105.184089266,14564078.29329402,110973.10920475423]
["   ii. Gilt",15312.644548855975,12007.249168512795,-3305.3953803431796,14875.2386527074,1684.9116241347806,1163.166411430353,-521.74521270442756,14862.813225999113,626.30716477571855,591.10832488945971,-35.198839886258838,null,null,13908.458142523898,11732.89148066017,-2175.5666618637279]
["  iii. Debt (other than assured return)",747716.81943869172,868350.14442398562,120633.32498529377,743782.95636839501,227271.21447247497,246356.28891370463,19085.074441229684,778265.56977298204,94997.113776562619,74311.218052837445,-20685.895723725145,null,null,603836.9443395033,780716.65209375322,176879.70775424986]
["   iv. Debt (assured return)",0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0]
["   v. Infrastructure Development",0,0,0,1907.94547929582,0,200,200,2153.0698180369013,0,0,0,null,null,0,0,0]
["B. Growth/Equity Oriented \n     Schemes (i+ii)",149182.6568389188,219549.96790657114,70367.311067652321,543541.26425261353,42390.948912016363,70722.954659639377,28332.005747623014,591376.88770552329,18266.129625064197,26431.523101479786,8165.3934764155811,null,null,127702.88246307812,189854.02904776167,62151.14658468352]
["    i. ELSS",4526.6050153568913,14623.567844674282,10096.96282931739,61403.187304316598,1596.9054648899087,3426.4906406750838,1829.5851757851754,66113.394015945407,472.53803419021096,1184.0221273185061,711.48409312829517,null,null,3705.1963751145731,10895.435070946829,7190.2386958322568]
["   ii. Others",144656.05182356192,204926.40006189686,60270.348238334933,482138.07694829698,40794.043447126453,67296.464018964296,26502.42057183784,525263.49368957791,17793.591590873988,25247.500974161281,7453.9093832872859,null,null,123997.68608796355,178958.59397681482,54960.907888851267]
["C. Balanced Schemes",14011.102322696965,50620.513363884493,36609.41104118753,84763.022289237895,4240.5612214441026,26497.392229500187,22256.831008056084,109512.79094119799,1427.2747899009446,8885.0170078483607,7457.7422179474161,null,null,11068.736144362258,41727.245063994735,30658.508919632477]
["D. Exchange Traded Fund (i+ii)",17281.5076970624,41335.301795494364,23278.461733979122,49915.468428861437,5019.2501067635512,7205.8358227000008,2186.5857159364496,53532.729032115123,1278.9504803581492,2561.384063030001,1282.4335826718518,null,null,13853.703307458398,34308.755131673366,19760.274611642129]
["    i. Gold ETF",861.51377544184231,86.181410989000014,-775.33236445284228,5479.8122647159398,230.17058327755046,11.4513426,-218.71924067755046,5173.5742078648418,82.408588390149163,0,-82.408588390149163,null,null,779.90593204184233,85.128719469000018,-694.77721257284236]
["    ii. Other ETFs",17281.5076970624,41335.301795494364,24053.794098431965,44435.656164145497,4789.0795234860007,7194.3844801000005,2405.3049566139998,48359.154824250283,1196.5418919680001,2561.384063030001,1364.8421710620009,null,null,13853.703307458398,34308.755131673366,20455.05182421497]
["E. Fund of Funds Investing Overseas",707.06407774574541,346.63626610926673,-360.42781163647868,1747.29641184098,158.60856353935688,47.287511422688844,-111.32105211666803,1663.3882793716402,55.926156972341659,17.422748747630845,-38.50340822471081,null,null,637.21793939250961,321.87707247186296,-315.34086692064665]
["Total (A+B+C+D+E)",17271638.441346116,17615462.678405654,343048.90469508071,1754619.082474191,4755647.1026404658,4849046.6197403977,93399.517099931778,1896290.7199531863,1568964.2072325358,1552371.625348615,-16592.581883921055,null,null,15224113.126425585,15622739.743184336,397931.83954617783]
["$ indicates as on June 30, 2017"]
["Source: SEBI.",null,null,null,null,null,"`",null,null,null,"`"]

{"sheet":"55","index":55,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":false,"merged":[[20,0,20,5],[0,0,0,16],[1,0,3,0],[1,1,1,8],[1,9,1,16],[2,1,2,4],[2,5,2,8],[2,9,2,12],[2,13,2,16]]}
["Table 55: Number of Schemes and Folios by Investment Objective           "]
["Type ","2016-17",null,null,null,null,null,null,null,"2017-18$"]
[null,"No. of Schemes",null,null,null,"No. of Folios",null,null,null,"No. of Schemes",null,null,null,"No. of Folios"]
[null,"Open","Closed","Interval","Total","Open","Closed","Interval","Total","Open","Closed","Interval","Total","Open","Closed","Interval","Total"]
["A. Income/Debt Oriented Schemes (i+ii+iii+iv)",349,1262,64,1675,8870830,1119944,8881,9999655,346,1063,59,1468,9093445,1141610,8335,10243390]
["    i. Liquid/Money Market",52,0,0,52,788860,0,0,788860,51,0,0,51,845527,0,0,845527]
["   ii. Gilt",41,0,0,41,86182,0,0,86182,41,0,0,41,87491,0,0,87491]
["  iii. Debt (other than assured return)",256,1255,64,1575,7995788,1119893,8881,9124562,254,1055,59,1368,8160427,1141553,8335,9310315]
["   iv. Debt (assured return)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["   v. Infrastructure Development",0,7,0,7,0,51,0,51,0,8,0,8,0,57,0,57]
["B. Growth/Equity Oriented \n     Schemes (i+ii)",358,126,0,484,39340247,1485964,0,40826211,359,131,0,490,41345543,1588122,0,42933665]
["    i. ELSS",43,21,0,64,7881090,570836,0,8451926,43,21,0,64,8167726,560977,0,8728703]
["   ii. Others",315,105,0,420,31459157,915128,0,32374285,316,110,0,426,33177817,1027145,0,34204962]
["C. Balanced Schemes",30,0,0,30,3548912,0,0,3548912,31,0,0,31,4062169,0,0,4062169]
["D. Exchange Traded Fund (i+ii)",63,0,0,63,915127,0,0,915127,63,0,0,63,887223,0,0,887223]
["    i. Gold ETF",12,0,0,12,364110,0,0,364110,12,0,0,12,361116,0,0,361116]
["    ii. Other ETFs",51,0,0,51,551017,0,0,551017,51,0,0,51,526107,0,0,526107]
["E. Fund of Funds  Investing Overseas",29,0,0,29,109726,0,0,109726,29,0,0,29,103937,0,0,103937]
["Total (A+B+C+D+E)",829,1388,64,2281,52784842,2605908,8881,55399631,828,1194,59,2081,55492317,2729732,8335,58230384]
["Note: Data for No. of Schemes also includes serial plans."]
["$ indicates as on June 30, 2017"]
["Source: SEBI."]

{"sheet":"56","index":56,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[9,0,9,9],[1,0,2,0],[1,1,1,3],[1,4,1,6],[1,7,1,9],[8,0,8,5]]}
["Table 56: Trends in Transactions on Stock Exchanges by Mutual Funds (₹ crore)"]
["Year/  Month","Equity",null,null,"Debt",null,null,"Total"]
[null,"Gross Purchase","Gross \nSales","Net \nPurchase/Sales","Gross \nPurchase","Gross \nSales","Net Purchase/Sales","Gross\n Purchase","Gross\n Sales","Net Purchase/Sales"]
["2016-17",376874.41000000003,320315.76,56558.65,1605937.0999999999,1286083.6100000001,319853.49,1982811.51,1606399.37,376412.13999999996]
["2017-18$",136695.53999999998,106987.51000000001,29708.03,438799.51,360734.33999999997,78065.17,575495.05000000005,467721.85000000003,107773.2]
["2017-04-04",42813.5,31569.25,11244.25,134337.1,78404.210000000006,55932.89,177150.6,109973.46,67177.14]
["2017-05-04",51059.27,41701.599999999999,9357.67,156917.4,147403.03,9514.3700000000008,207976.66999999998,189104.63,18872.04]
["2017-06-04",42822.77,33716.660000000003,9106.11,147545.01,134927.1,12617.91,190367.78,168643.76,21724.02]
["$ indicates as on June 30, 2017"]
["Source: SEBI"]

{"sheet":"57","index":57,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,1,1,3],[1,4,1,6],[13,0,13,3]]}
["Table 57: Asset Under Management by Portfolio Manager"]
["Year/Month","2016-17",null,null,"2017-18$"]
["Particulars","Discretionary","Non-Discretionary","Advisory","Discretionary#","Non-Discretionary","Advisory*"]
["No. of Clients",70994,4674,1482,82753,4903,1556]
["AUM (` in crore)"]
["Listed  Equity",73912.86,13623.49,null,84392.8,13071.77]
["Unlisted  Equity",683.15,42.78,null,585.66,47.42]
["Plain Debt",866612.64,52883.64,null,911524.9,54496.71]
["Structured Debt",281.60000000000002,544.17999999999995,188385,358.09,567.64,183171.82]
["Equity Derivative",188.19,-0.02,null,215.72,0]
["Mutual Fund",8687.9,7563.2,null,10207.52,7883.53]
["Others",16669.64,404.12,null,16131.7,450.51]
["Total",967036,75061.389999999985,null,1023416.39,76517.58]
["Notes:\n1. *Value of Assets for which Advisory Services are being given.\n2. #Of the above AUM Rs. 896324.254 Crore is contributed by funds from EPFO/PFs.\n3. The above data is based on the monthly reports received from portfolio managers."]
["$ indicates as on June 30, 2017"]
["Source: SEBI."]

{"sheet":"58","index":58,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,0,18,2],[0,0,0,11],[1,0,2,0],[1,1,2,1],[1,2,1,6],[1,7,1,11],[17,0,17,12]]}
["Table 58: Progress Report of NSDL & CDSl as on end of June-2017 (Listed Companies)"]
["Parameter","Unit","NSDL",null,null,null,null,"CDSL"]
[null,null,"2017-06-01","2017-05-01","2016-06-01","%\nChange during the year","%\nChange during the month","2017-06-01","2017-05-01","2016-06-01","%\nChange during the year","%\nChange during the month"]
["Number of companies signed up to make their shares available for dematerialization","Number",5929,6330,6210,-4.5249597423510464,-6.3349131121642976,6562,6574,6428,2.0846297448662106,-0.18253726802555523]
["Number of Depository Participants (registered)","Number",268,268,268,0,0,590,589,580,1.7241379310344827,0.1697792869269949]
["Number of Stock Exchanges (connected) ","Number",3,3,4,-25,0,3,3,3,0,0]
["Number of Investors Accounts","Lakh",158.99,157.84,147.69,7.6511612160606752,0.72858590978206139,127.50757,125.80237,112.24276,13.599817039424188,1.3554593605827976]
["Quantity of Shares dematerialized","crore",45796.770173199999,45376.653854099997,42284.101952099998,8.3073024113866687,0.92584243970656266,13445.916595299999,13392.9466744,12617.31,6.5672207094856176,0.39550609875307491]
["Value of Shares dematerialized","₹ crore",10808454.660675731,10809111.465730267,8897211.0845986791,21.481378354453877,-6.0764019005489578E-3,1536000.9569000001,1571027.439,1241751.6599999999,23.696307915545706,-2.2295270744790541]
["Quantity of Securities dematerialized #","crore",48469.540540254602,48023.851512422196,44462.122666186297,9.013105164041054,0.92805765009730867,14235.389634520798,14157.511457922101,13083.97,8.8002313863513795,0.55008379707239219]
["Value of Securities dematerialized #","₹ crore",13126174.536633365,13067223.255736383,10782612.047090709,21.734645365220011,0.45113854522308816,1616697.6022000001,1652398.3417,1302574.1668205434,24.11558922177932,-2.1605407485020054]
["Quantity of shares settled during the month","crore",911.5426023,1006.014707,809.20130070000005,12.647199344769906,-9.3907279926077702,558.96853659999999,721.60884359999989,538.36157399999991,3.8277179492754976,-22.538568982693093]
["Average Quantity of shares settled daily (quantity of shares settled during the month (divided by 30))","crore",30.384753410000002,33.533823566666669,26.973376689999998,12.647199344769925,-9.3907279926077667,18.632284553333331,24.053628119999996,17.945385799999997,3.8277179492754887,-22.5385689826931]
["Value of shares settled during the month in dematerialized form","₹ crore",274292.60555173701,246945.25888306278,176241.20009023606,55.634780863554226,11.074254590821749,60537.011462800001,72311.52576277699,47381.123135157992,27.766096405342505,-16.283039495811643]
["Average Value of shares settled daily (value of shares settled during the month (divided by 30))","₹ crore",9143.0868517245763,8231.508629435426,5874.7066696745351,55.634780863554376,11.074254590821861,2017.9003820933333,2410.3841920925665,1579.370771171933,27.766096405342505,-16.283039495811654]
["Training Programmes conducted for representatives of Corporates, DPs and Brokers","Number",10,20,15,-33.333333333333329,-50,156,301,259,-39.768339768339764,-48.172757475083053]
["The ratio of dematerialized equity shares to the total outstanding shares (market value)","percent",85.49,85.05,85.6,-0.12850467289719561,0.51734273956495913,11.132208263466801,13.268532494917901,12.66,-12.067865217481828,-16.100682063139633]
["Notes: 1. Shares includes only equity shares. 2. Securities include common equity shares, preference shares, debenture, MF units, etc. 3. No. of days taken for calculating Daily Average is 30 days instead of Actual settlement days. 4. Quantity and value of shares mentioned are single sided. 5. #Source for listed securities information: Issuer/ NSE/BSE."]
["Source: NSDL and CDSL."]

{"sheet":"59","index":59,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[10,0,10,5],[0,0,0,10],[1,0,2,0],[1,1,1,5],[1,6,1,10],[8,0,9,10]]}
["Table 59: Progress of Dematerialisation at NSDL and CDSL (Listed and Unlisted Companies)"]
["Year/ Month","NSDL",null,null,null,null,"CDSL"]
[null,"Companies Live \n","DPs Live\n","DPs\nLocations ","Demat \nQuantity \n(million securities)","Demat Value (₹ crore)","Companies Live\n","DPs Live","DPs\nLocations\n","Demat \nQuantity \n(million securities)","Demat Value (₹ crore)"]
["2016-17",17835,264,27389,1317620,14648687,9887,588,17489,255227.4,1773585.34]
["2017-18$",18396,268,27417,1362664.81,15185478.458000001,10017,590,17387,256094.39194419494,1766361.5631000001]
["2017-04-01",18039,265,27380,1336753.74,12660053.331,9934,589,17481,253520.91100000002,1830695.08]
["2017-05-01",18233,268,27395,1349820.23,15139573.823000001,9968,589,17415,254730.043515075,1799049.7305000001]
["2017-06-01",18396,268,27417,1362664.81,15185478.458000001,10017,590,17387,256094.39194419494,1766361.5631000001]
["Notes : 1. For CDSL, the current and historical data of Companies Live has been revised to exclude MF schemes count. 2. The Companies Live figure  includes only the number of mutual fund companies and not the mutual fund schemes. 3. DPs Locations' represents the total live (main DPs and branch DPs as well as non-live (back office connected collection centres)."]
[]
["$ indicates as on June 30, 2017"]
["Source: NSDL and CDSL."]
[]
[null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"60","index":60,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,8,1,9],[17,0,17,8],[0,0,0,2],[1,0,2,0],[1,1,2,1],[1,2,1,3],[1,4,1,5],[1,6,1,7]]}
["Table 60: Depository Statistics for June-2017"]
["Particulars","Unit","Debt",null,"Equity",null,"Others",null,"Total"]
[null,null,"Listed","Unlisted","Listed","Unlisted","Listed","Unlisted","Listed","Unlisted"]
["NSDL"]
["Issuers(debt)/ Companies(equity), who have issued the active instument ","Number",773,1231,5929,9790,63,3556,6765,14577]
["Active Instruments ","Number",12272,4711,11885,10307,7270,29315,31427,44333]
["Dematerialised Quantity ","Lakh",106019.57397,283335.03018,4579677.0173199996,6179340.0447399998,161257.46273545999,2317018.986785477,4846954.05402546,8779694.0617054775]
["Dematerialised Value ","₹ crore",2235016.9044886385,322050.71990722435,10808454.660675731,602136.36364322912,82702.971468996562,1135116.8379876362,13126174.536633365,2059303.9215380896]
["Quantity settled during the month ","Lakh",3475.36148,4757.9280699999999,91154.26023,15.105130000000001,868.48565886999995,2144.6066891399946,95498.107368870013,6917.6398891399949]
["Value Settled during the month","₹ crore",454874.07120280003,30819.354318900001,274292.60555173724,19.152100789999999,1657.5575581710002,813.21842416999971,730824.23431270826,31651.72484386]
["CDSL"]
["Issuers(debt)/ Companies(equity), who have issued the active instument ","Number",569,310,6562,2529,2497,384,9628,3223]
["Active Instruments ","Number",9818,1446,6671,2682,18711,1446,35200,5574]
["Dematerialised Quantity ","Lakh",3090.91113,26837.24408,1344591.6595299998,980137.50400000007,75856.392792079991,130430.20790987001,1423538.9634520798,1137404.95598987,null,null," "]
["Dematerialised Value ","₹ crore",53443.701099999998,25511.970600000001,1536000.9569000001,104930.0346,27252.944200000002,19221.955700000002,1616697.6022000001,149663.96090000001]
["Quantity settled during the month ","Lakh",39.977180000000004,0,55896.853660000001,0,7911.0567317999994,0,63847.887571799991,0]
["Value Settled during the month","₹ crore",1050.4544656999999,0,60537.011462800001,0,4747.5259624999999,0,66334.991890999998,0]
["Note: The categories included in Others are Preference Shares, Mutual Fund Units, Warrants, PTCs, Treasury Bills, CPs, CDs and Government Securities. \n"]
["Source: NSDL and CDSL."]

{"sheet":"61","index":61,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,0,4,0],[5,0,7,0],[8,0,10,0],[11,0,13,0]]}
["Table 61 : Number of Commodities Permitted and traded at Exchanges"]
["Exchanges","Particulars","Agriculture","Metals other than bullion","Bullion","Energy "]
["NCDEX","Permitted for trading",20,2,1,1]
[null,"Contracts floated ",20,2,1,0]
[null,"Traded",17,0,0,0]
["MCX","Permitted for trading",6,5,2,2]
[null,"Contracts floated ",6,5,2,2]
[null,"Traded",5,5,2,2]
["NMCE","Permitted for trading",12,0,0,0]
[null,"Contracts floated ",12,0,0,0]
[null,"Traded",7,0,0,0]
["COC, Hapur (Regional Exchange)","Permitted for trading",1,0,0,0]
[null,"Contracts floated ",1,0,0,0]
[null,"Traded",1,0,0,0]
["Source: NCDEX, MCX, NMCE and COC Hapur."]

{"sheet":"62","index":62,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,8],[2,0,3,0],[2,1,2,4],[2,5,2,8]]}
["Table 62: Trends in Commodity Indices"]
[]
["Year/  Month","MCX COMDEX",null,null,null,"NCDEX Dhaanya"]
[null,"Open","High","Low","Close","Open","High","Low","Close"]
[" 2016-17",2730.58,3435.43,2673.76,3242.79,2869.73,3411.86,2896.54,3080.79]
["2017-18$",3244.07,3291.16,2966.02,3056.81,3107.24,3185.09,2794.83,2875.74]
["2017-04-01",3244.07,3291.16,3110.03,3148.19,3107.24,3185.09,3013.79,3019.45]
["2017-05-02",3147.24,3186.87,2995.12,3110.18,3033.29,3039.36,2795.32,2807.32]
["2017-06-03",3109.91,3116.85,2966.02,3056.81,2821.07,2907.61,2794.83,2875.74]
["$ indicates as on June  30, 2017"]
["Source: MCX and NCDEX"]
[]
[]
[]
[]
[]
[null,null,null," "]

{"sheet":"63","index":63,"n_rows":12,"n_cols":20,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,18,3,18],[2,19,3,19],[10,0,10,17],[11,0,11,3],[2,11,3,11],[2,12,3,12],[2,13,3,13],[2,14,3,14],[2,15,3,15],[2,16,3,16],[2,7,3,7],[2,8,3,8],[2,9,3,9],[2,10,3,10],[2,17,3,17],[0,0,0,8],[0,9,0,17],[0,18,0,19],[1,0,3,0],[1,1,3,1],[1,2,1,4],[1,5,1,7],[1,8,1,10],[1,11,1,13],[1,14,1,16],[1,17,1,19],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6]]}
["Table 63: Trends in Commodity Futures at MCX "]
["Year/  Month","No.of Trading days","Agriculture",null,null,"Metals",null,null,"Bullion",null,null,"Energy",null,null,"Total",null,null,"Open interest at the end of the period"]
[null,null,"Volume ('000 tonnes)","No. of contracts","Turnover \n(` crore)","Volume ('000 tonnes)","No of contracts","Turnover (` crore)","Volume ('000 tonnes)","No of contracts","Turnover (`crore)","Volume ('000 tonnes)*","No of contracts","Turnover (`crore)","Volume ('000 tonnes)","No of contracts","Turnover (`crore)","Volume ('000 tonnes)","No of contracts","Value                (` crore)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Rs.crore)"]
["2016-17",260,15947.237979999996,3087740,139312.46434179999,93077.857749999996,64421776,1753887.3819669958,207.31740535900028,37151550,2040270.4695600041,674224.55275033519,117849477,1932190.901485,783456.96588569414,222510543,5865661.2173537994,539.56172677249992,284204,9229.7676900999995]
["2017-18$",64,3031.9461899999997,561635,25999.087390199998,21187.401250000006,14856874,411528.95577699994,39.752054210999987,6820324,345761.93345720001,148763.35413524049,26172733,418140.37212749996,173022.45362945148,48411566,1201430.3487519,605.36959214299998,343340,10151.02374925]
["2017-04-01",19,1079.1424100000002,195664,9267.3135478000004,6867.4791500000019,4866800,135571.88294200003,10.693067772000001,1908513,100564.99675579998,39029.269324451008,6962917,118855.93952850001,46986.583952223009,13933894,364260.1327741,553.37462682799992,323663,9003.3864713000003]
["2017-05-02",23,1099.9832000000001,203738,9589.1520511999988,6807.9145000000044,4826541,130356.90458325004,13.995771910999993,2435833,123722.6986478,56277.384172092985,9755773,157675.11595899993,64199.277644003989,17221885,421343.87124124996,514.27989861900005,329663,8848.4290891500004]
["2017-06-03",22,852.82057999999972,162233,7142.6217911999984,7512.0076000000017,5163533,145600.16825174991,15.063214527999992,2475978,121474.2380536,53456.700638696486,9454043,141609.31664000003,61836.592033224486,17255787,415826.34473654995,605.36959214299998,343340,10151.02374925]
["$ indicates as on June  30, 2017"]
["Notes: 1. The following commodities are considered in each category: \nAgriculture: Cardamom, Cotton, Crude Palm Oil, Castorseed, RBD Palmloein and Mentha Oil ;  Metals: Aluminium, Copper, Lead, Nickel, Zinc and their variants;  \nBullion: Gold, Silver and their variants; Energy: Brent Crude Oil, Crude Oil, Crude Oil Mini, Natural Gas. \n2. *Natural Gas volumes are in mm BTU and is not included for computing the Total Volume and Total Open Interest in '000 tonnes"]
["Source: MCX"]

{"sheet":"64","index":64,"n_rows":28,"n_cols":19,"rows_kept":28,"cut":false,"hidden":false,"merged":[[10,0,10,13],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,8,3,8],[2,9,3,9],[0,0,0,8],[0,9,0,13],[1,0,3,0],[1,1,3,1],[1,2,1,4],[1,5,1,7],[1,8,1,10],[1,11,1,13],[2,2,3,2],[2,3,3,3],[2,10,3,10],[2,11,3,11],[2,12,3,12],[2,13,3,13]]}
["Table 64: Trends in Commodity Futures at NCDEX "]
["Year/  Month","No.of Trading days","Agriculture",null,null,"Bullion",null,null,"Total",null,null,"Open interest at the end of the period"]
[null,null,"Volume\n('000 tonnes)","No. of contracts","Turnover (` crore)","Volume \n('000 tonnes)","No of contracts","Turnover (` crore)","Volume ('000 tonnes)","No of contracts","Turnover (` crore)","Volume ('000 tonnes)","No. of Contracts","Value                  (` crore)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(Rs.crore)"]
["2016-17",260,128789.68800000002,17750779,596529.72767399997,1.1819999999999999E-3,1182,322.25477000000001,128789.689182,17751961,596851.98244399996,1065.356,126453,4878.2]
["2017-18$",62,29438.054999999997,3422983,126311.64562199995,0,0,0,29438.054999999997,3422983,126311.64562199995,880.56200000000001,105304,3582.22]
["2017-04-01",19,9237.8509999999878,1084152,43954.75728199997,0,0,0,9237.8509999999878,1084152,43954.75728199997,1035.741,118879,4605.26]
["2017-05-02",22,10125.65800000001,1173570,43262.841514999993,0,0,0,10125.65800000001,1173570,43262.841514999993,1002.683,116185,3914.99]
["2017-06-03",21,10074.545999999998,1165261,39094.046824999998,0,0,0,10074.545999999998,1165261,39094.046824999998,880.56200000000001,105304,3582.22]
["$ indicates as on June  30, 2017"]
["Note:  The following commodities are considered in each category: \nAgriculture :  Barley, CastorSeed, Cottonseed Oilcake,  Coriander, Cotton, Guargum 5 MT, Guarseed 10 MT, Jeera, Kapas, Rape/Mustardseed, Shankar Kapas, Sugar Medium,  Soybean, Soymeal, Refined Soy Oil, Turmeric, Wheat, Maize, Rape/Mustard Oilcake\nBullion: Gold, Silver and their variants; "]
["Source: NCDEX"]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]

{"sheet":"65","index":65,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,7,3,7],[10,0,10,7],[0,0,0,7],[1,0,3,0],[1,1,3,1],[1,2,1,4],[1,5,1,7],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6]]}
["Table 65: Trends in Commodity Futures at NMCE "]
["Year/  Month","No.of Trading days","Agriculture",null,null,"Open interest at the end of the period"]
[null,null,"Volume ('000 tonnes)","No. of contracts","Turnover (` crore)","Volume\n('000 tonnes)","No of contracts","Value                  (` crore)"]
[null,null,null,null,null,null,null,"(Rs.crore)"]
["2016-17",247,5564.19085,1230289,28441.538271599999,4.8156249999999998,3328,51.225070199999998]
["2017-18$",61,1769.61085,464298,8149.7644376000007,4.5465249999999999,3025,41.060047599999997]
["2017-04-01",18,470.041675,135463,2366.8971594,3.8702749999999999,2710,40.949722800000004]
["2017-05-02",22,600.54984999999999,157039,2769.5055652000001,4.0885749999999996,2661,35.557564800000002]
["2017-06-03",21,699.01932499999998,171796,3013.3617129999998,4.5465249999999999,3025,41.060047599999997]
["$ indicates as on June  30, 2017"]
["Note : Agricultural commodites of Rubber, Castor Seed, Pepper, Guarseed, Rape/Mustard Seed, Isabgul Seed and Raw Jute are traded at NMCE."]
["Source: NMCE"]
[null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null," "]
[]
[]
[]
[]
[null,null,null,null,"`"," "]

{"sheet":"66","index":66,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,2,0],[1,1,1,4],[1,5,1,6]]}
["Table 66: Category-wise Share in Turnover at MCX and NCDEX (percent) "]
["Year/ Month","Percentage Share in Turnover at MCX",null,null,null,"Percentage Share in Turnover at NCDEX"]
[null,"Agriculture","Metals","Bullion","Energy","Agriculture","Bullion"]
["2016-17",2.3750513229376145,29.90093217075081,34.783298829529741,32.940717676781844,99.94,0.06]
["2017-18$",2.1640112069092483,34.2532512354557,28.779190888293559,34.803546669341486,100,0]
["2017-04-01",2.5441470844538534,37.218424621306681,27.60801627944458,32.629412014794887,100,0]
["2017-05-02",2.2758494203205135,30.93836495099065,29.363830137915969,37.421955490772874,100,0]
["2017-06-03",1.7176934269821846,35.014656982350658,29.212732572430195,34.054917018236956,100,0]
["$ indicates as on June  30, 2017"]
["Source: MCX and NCDEX"]
[]
[null,null," "]
[null,null,null,null,null,null," "]

{"sheet":"67","index":67,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[11,0,11,8],[12,0,12,8],[0,0,0,8],[1,0,3,0],[1,1,1,4],[1,5,1,8],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8]]}
["Table 67: Participant-wise Percentage Share of Turnover & Open Interest at MCX"]
["Year/ Month","Turnover",null,null,null," Open Interest at the end of period"]
[null,"Agriculture Commodities",null,"Non-Agriculture Commodities",null,"Agriculture Commodities",null,"Non-Agriculture Commodities"]
[null,"Pro","Client ","Pro","Client ","Pro","Client ","Pro","Client "]
["2016-17",35.275130739435923,64.724869260564077,19.636723386964807,80.363276613035197,10.716124948603825,89.28387505139618,18.225992863967242,81.774007136032751]
["2017-18$",34.838511093716981,65.161488906283012,19.418767706286342,80.581232293713654,12.823055895466664,87.176944104533334,21.028220067946698,78.971779932053295]
["2017-04-01",36.468973882968683,63.531026117031317,19.661532654272072,80.338467345727921,10.858876984754978,89.141123015245029,21.80548185615789,78.194518143842103]
["2017-05-02",36.431192583528031,63.568807416471969,20.030271244379467,79.969728755620537,13.864729475002457,86.135270524997537,20.541656813048952,79.458343186951041]
["2017-06-03",30.584824456076682,69.415175543923311,18.591797455378572,81.408202544621417,12.823055895466664,87.176944104533334,21.028220067946698,78.971779932053295]
["$ indicates as on June  30, 2017"]
["1. All trades executed under client codes other than *OWN* (proprietary account) is treated as client trades and is computed at client Level.  "]
["2. All Commodities falling under the category of Energy, Bullion and Metals are treated as Non-Agri., \nwheresas other commodities are treated as Agri.  "]
["3. Open Interest provided is at end of the respective FY or Month as applicable and computed at client level. \nThe OI value is considered before marking of delivery on the expiry date."]
["Source: MCX"]
[]
[null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," ",null,null," "]

{"sheet":"68","index":68,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,8],[0,9,0,10],[1,0,3,0],[1,1,1,5],[1,6,1,10],[2,4,2,5],[2,6,2,8],[2,9,2,10]]}
["Table 68: Partcipant-wise  Percentage Share of Turnover & Open Interest at NCDEX"]
["Year/ Month","Turnover (Percent)",null,null,null,null," Open Interest at the end of period (Percent)"]
[null,"Agriculture Commodities",null,null,"Non-Agriculture Commodities",null,"Agriculture Commodities",null,null,"Non-Agriculture Commodities"]
[null,"Pro","Client ","Hedgers","Pro","Client ","Pro","Client ","Hedgers","Pro","Client "]
["2016-17",41.560108200399654,58.165458243959058,0.27443355564129068,73.638115581656095,26.361884418343905,20.658970086661714,78.329096319362819,1.011933593975469,0,0]
["2017-18$",40.627166301095194,59.156951308443325,0.21588239046147439,0,0,19.86134322613934,79.206943469980089,0.93171330388057749,0,0]
["2017-04-01",39.48011146590143,60.295726125766144,0.22416240833241799,0,0,21.215150089126865,77.731933230268965,1.0529166806041708,0,0]
["2017-05-02",41.62563878578375,58.16441205387617,0.2099491603400751,0,0,22.493386402480784,76.452901050856781,1.0537125466624304,0,0]
["2017-06-03",40.811894171306349,58.974967021721334,0.2131388069723065,0,0,19.86134322613934,79.206943469980089,0.93171330388057749,0,0]
["$ indicates as on June  30, 2017"]
["Source: NCDEX",null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"69","index":69,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,1,1,2],[1,3,1,4]]}
["Table 69: Participant-wise Percentage Share of Turnover & Open Interest at NMCE"]
["Year/    Month","Turnover",null," Open Interest at the end of Period"]
[null,"Pro","Client ","Pro","Client "]
["2016-17",4.8013516458200289,95.198648354179966,0.9642873794794149,99.035712620520584]
["2017-18$",1.7669290622147882,98.233070937785214,0.85061227239805282,99.149387727601948]
["2017-04-01",2.9217603234409459,97.078239676559051,0.94446267731466294,99.055537322685339]
["2017-05-02",1.6222573828536604,98.377742617146339,1.2987714810678388,98.701228518932155]
["2017-06-03",0.99281097323745027,99.007189026762561,0.85061227239805282,99.149387727601948]
["$ indicates as on June  30, 2017"]
["Note: Profile of participants as hedgers or otherwise is not available with the Exchange"]
["Source: NMCE"]

{"sheet":"70","index":70,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[[3,1,3,9],[7,1,7,9],[14,1,14,9],[22,1,22,9],[26,0,26,1],[0,0,0,9],[1,0,2,0],[1,1,2,1],[1,2,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9]]}
["Table 70: Commodity-wise Turnover and trading volume at MCX"]
["Sr.No","Name of the Commodity","2017-18$",null,"2016-06-01",null,"2017-05-01",null,"2017-06-01"]
[null,null,"Volume\n('000 tonnes)","Value \n(` crore)","Volume\n('000 tonnes)","Value \n(` crore)","Volume\n('000 tonnes)","Value \n(` crore)","Volume\n('000 tonnes)","Value \n(` crore)"]
["A","Bullion"]
[1,"Gold",0.66168621100000025,190404.03040640001,0.50719028699999991,154335.74979139995,0.24564191099999991,69983.504873100028,0.21961452800000003,63364.954074300003]
[2,"Silver",39.090367999999998,155357.90305080006,20.347206999999997,84162.042123000007,13.750129999999997,53739.19377469999,14.843599999999993,58109.283979300017]
[null,"Total for A",39.752054211000001,345761.93345720007,20.854397286999998,238497.7919144,13.995771910999997,123722.69864780002,15.063214527999992,121474.23805360001]
["B","Metals other than Bullion"]
[1,"Aluminium",2635.8829999999998,32539.307660000002,1288.2529999999995,13811.505870000003,878.36299999999983,10850.396324999998,838.73300000000006,10220.756149999999]
[2,"Copper",2698.6257499999997,99530.618097500002,1490.7872499999999,46568.094734999999,804.57825000000003,29387.388196249998,1002.2172500000001,37166.671321249989]
[3,"Lead",6002.628999999999,83835.90939500001,2122.7360000000003,24620.536979999993,2016.3300000000004,27680.637680000011,2026.6630000000002,28019.864155000003]
[4,"Nickel",702.37849999999992,42048.361534499985,234.47180000000003,14198.485814999998,246.25925000000001,14569.860772,229.2603500000001,13295.5411355]
[5,"Zinc",9147.8849999999984,153574.75908999998,4231.7069999999994,57700.901485000009,2862.3839999999991,47868.621609999995,3415.134,56897.335489999998]
[null,"Total for  B",21187.401249999995,411528.95577699994,9367.9550499999987,156899.52488499999,6807.914499999999,130356.90458325,7512.0076000000008,145600.16825175]
["C","Agricultural commodities"]
[1,"Cardamom",1.7356,192.96219099999993,1.8324000000000003,157.420558,0.4607,48.857498999999997,0.60860000000000003,61.722297999999995]
[2,"Castorseed",0.05,0.2316,0,0,0,0,0,0]
[3,"Cotton",996.62074999999993,12222.038299999997,475.98300000000006,5386.7979499999983,379.48250000000002,4691.0877249999994,243.55049999999997,2910.3200500000003]
[4,"CPO",1962.4699999999989,9695.5127899999989,827.01999999999987,4273.07042,697.17000000000019,3480.6554900000001,592.63999999999987,2864.3763200000008]
[5,"Mentha Oil",39.741840000000018,3719.9418732000004,17.858520000000002,1513.8808955999998,14.130000000000003,1321.2558072000002,14.181480000000002,1296.4310532000002]
[6,"RBD Palmolein",31.32,168.35877000000002,0,0,8.74,47.295530000000007,1.8400000000000003,9.7720700000000011]
[null,"Total for C",3031.9461899999988,25999.087390199995,1322.6939199999999,11331.169823599997,1099.9832000000004,9589.1520511999988,852.82057999999984,7142.6217912000011]
["D","Energy"]
[1,"Crude Oil",148763.35413524054,338863.39594000007,60924.305112597489,146872.845256,56277.384172092985,129098.745734,53456.700638696486,115114.31796500004]
[2,"Natural Gas (trln. Btu)",3893.4324999999999,79276.976187500026,1752.9449999999999,31057.533550000004,1362.1112499999999,28576.370224999999,1365.39,26494.998675000003]
[null,"Total for D*",148763.35413524054,418140.37212750013,60924.305112597489,177930.37880599999,56277.384172092985,157675.11595899999,53456.700638696486,141609.31664000003]
["Grand Total (A+B+C+D)",null,173022.45362945154,1201430.3487519003,71635.808479884494,584658.865429,64199.277644003982,421343.87124124996,61836.592033224486,415826.34473655006]
["$ indicates as on June  30, 2017"]
["Note : *Natural Gas volumes are in Trillion BTU and is not included for computing the Total Volume in '000 tonnes"]
["Conversion factors: Cotton (1 Bale=170 kg), Crude Oil (1 Tonne = 7.33Barrels)"]
["Source : MCX"]

{"sheet":"71","index":71,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,2,0],[1,1,2,1],[1,2,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9]]}
["Table 71: Commodity-wise monthly turnover and trading volume at NCDEX "]
["Sr.No","Name of Commodity","2017-18$",null,"2016-06-01",null,"2017-05-01",null,"2017-06-01"]
[null,null,"Volume in 1000 tons","Value (` crore)","Volume in 1000 tons","Value (` crore)","Volume in 1000 tons","Value (` crore)","Volume in 1000 tons","Value (` crore)"]
[null,"Agricultural commodities"]
[1,"Barley",107.94,160.11000000000001,93.7,150.45000000000002,48.55,71.459999999999994,30.92,43.6,null,null," "]
[2,"Castorseed",2735.53,12446.619999999999,5.0000000000000001E-3,5.0000000000000001E-3,947.73,4249.78,886.98,3841.24]
[3,"Chana",5.0000000000000001E-3,5.0000000000000001E-3,322.90199999999999,2133.14,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3]
[4,"Chilli",5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0.06,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3]
[5,"Cotton seed oil cake",4614.7299999999996,8658.9200000000019,1367.47,3387.8199999999993,1546.51,2995.28,1900.53,3235.26]
[6,"Cotton",5.0000000000000001E-3,5.0000000000000001E-3,0.747,35.22,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3]
[7,"Crude palm oil",5.0000000000000001E-3,5.0000000000000001E-3,0.02,0.11,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3]
[8,"Coriander",1167.9099999999999,7037.76,151.79,1067.3600000000004,442.73,2441.29,279.82,1385.82]
[9,"Guar seed",6344.2719999999999,23296.89,2276.46,7157.7500000000009,2009.87,7282.53,2192.16,7417.01]
[10,"Guargum",1669.46,13128.33,573.64200000000005,3195.23,554.83500000000004,4322.87,530.93499999999995,3845.67]
[11,"Jeera",667.38599999999997,12470.66,353.24700000000001,6133.3599999999988,233.89500000000001,4255.3599999999997,165.91200000000001,3074.82]
[12,"Kapas",734.87200000000007,3468.2799999999997,77.152000000000001,1416.7399999999998,208.208,1007.57,342.68400000000003,1523.97]
[13,"Maize",124.25999999999999,166.42000000000002,376.87,590.94000000000005,38.299999999999997,51.21,57.46,74.88]
[14,"Rmseed",3199.29,11813.25,2472.85,11591.78,1245.8,4574.09,1043.53,3723.76]
[15,"RMCAKE",14.65,26.61,5.0000000000000001E-3,5.0000000000000001E-3,6.23,11.35,0.78,1.31]
[16,"Sugar",10.73,40.17,201.91,737.46999999999991,4.0199999999999996,14.94,0.63,2.31]
[17,"Soya bean",4581.2000000000007,13212.970000000001,1931.23,7439.5500000000011,1545.22,4424.34,1519.92,4283.67]
[18,"Soya oil",2759.69,17270.560000000001,2483.23,16146.440000000004,1011.13,6325.78,892.68,5631.47]
[19,"Soy Meal",0.77,1.8900000000000001,5.0000000000000001E-3,5.0000000000000001E-3,0.12,0.28999999999999998,5.0000000000000001E-3,5.0000000000000001E-3]
[20,"Degummed Soy Oil",7.17,41.87,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,7.17,41.87]
[21,"Turmeric",462.60500000000002,2687.68,294.8,2396.9399999999996,197.1,1096.9100000000001,145.97499999999999,844.4]
[22,"Wheat",235.59,382.62,216.28,379.72,85.41,137.78,76.459999999999994,122.97]
[null,"Total for A",29438.074999999997,126311.62999999998,13194.324999999999,63960.1,10125.682999999999,43262.854999999996,10074.570999999998,39094.055000000008]
[null,"$ indicates as on June  30, 2017"]

{"sheet":"72","index":72,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,0,11,1],[12,0,12,1],[18,3,18,7],[0,0,0,4],[0,5,0,9],[1,0,2,0],[1,1,2,1],[1,2,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9]]}
["Table 72: Commodity-wise Turnover and Volume at NMCE "]
["Sr.No","Name of the Commodity","2017-18$",null,"2016-06-01",null,"2017-05-01",null,"2017-06-01"]
[null,null,"Volume\n('000 tonnes)","Value \n(` crore)","Volume\n('000 tonnes)","Value \n(` crore)","Volume\n('000 tonnes)","Value \n(` crore)","Volume\n('000 tonnes)","Value \n(` crore)"]
[1," Castorseed ",198.73,896.47119999999995,133.85,414.47187300000002,68.930000000000007,312.20938999999998,82.76,357.60341]
[2," Guarseed ",267.01900000000001,978.43321600000002,7.6980000000000004,24.205760999999999,88.733000000000004,324.13508999999999,97.710999999999999,331.29843499999998]
[3," Isabgulseed ",149.70824999999999,1724.914023,52.862625000000001,608.87838999999997,48.903750000000002,564.35129600000005,57.641624999999998,644.48958400000004]
[4,"Pepper Mini",0.15259999999999999,8.3179756000000005,0,0,6.8099999999999994E-2,3.7159901999999998,5.4700000000000006E-2,2.7988040000000001]
[5," Rape/mustardseed ",634.04,2041.52,148.01,597.89346499999999,217.37,705.74024499999996,255.13,784.43]
[6," Rawjute ",469.19,1819.288826,73.7,441.66482600000001,158.19999999999999,618.49824000000001,190.74,705.69384700000001]
[7," Rubber ",50.771000000000001,680.82322699999997,23.672000000000001,318.02520800000002,18.344999999999999,240.85531399999999,14.981999999999999,187.04952800000001]
[null,"Total",1769.61085,8149.7684675999999,439.79262499999999,2405.1395230000003,600.54985000000011,2769.5055652000001,699.01932499999998,3013.3636080000001]
["$ indicates as on June 30, 2017"]
["Source : NMCE"]

{"sheet":"73","index":73,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,4,0,5],[1,0,1,3],[1,4,1,5],[2,0,2,3],[2,4,2,5],[39,0,39,3],[40,0,40,4],[4,0,5,0],[3,0,3,3],[3,4,3,5]]}
["Table 73: Macro Economic Indicators"]
["I. GDP at constant prices (2011-12 prices) for 2016-17 (`crore)*                         ",null,null,null,12189854]
["II. Gross Saving as a percent of Gross national Disposable Income at current market prices in 2015-16              ",null,null,null,31.6]
["III. Gross Capital Formation as a percent of GDP at current market prices in 2016-17@",null,null,null,27.1]
["IV.  Monetary and Banking Indicators                  ","February","March","April","May","June"]
[null,2017,2017,2017,2017,2017]
["Cash Reserve Ratio (percent)",4,4,4,4,4]
["Repo Rate (percent)",6.75,6.25,6.25,6.25,6.25]
["Money Supply (M3)  (` crore)",12308280,12839080,12682860,12722950,128094.5]
["Aggregate Deposit (` crore)",10486720,10805150,10591720,10551180,106056.2]
["Bank Credit (` crore)",7485250,7881889.9999999991,7631500,7593550,76640]
["V. Interest Rate                        "]
["Call Money Rate (Weighted Average)",6.73,5.97,6,6.04,6.07]
["91-Day-Treasury Bill (Primary Yield)",7.35,5.82,6.19,6.85,6.27]
["Base rate (percent)","9.30/9.70","9.25/9.60","9.10/9.60","9.10/9.60","9.10/9.60"]
["Term Deposit Rate > 1 year (Maximum) ","7.00-7.90","6.50-7.00","6.50/7.00","6.25/6.90","6.25/6.90"]
["VI. Capital Market Indicators (`crore)"]
["Turnover (BSE+NSE) ",544629.85602624505,845346.69586944394,547180.59459065995,679607.62,572239.25794643001]
["Market Cap-BSE ",11759366.880000001,12154525.460000001,12484962.9,12580118.73,12596811.99]
["Market Cap-NSE ",11562209.7991095,11978420.9020945,12303874.7516181,12416788.8648584,12430129.1713464]
["Net FPI Investment in Equity ",9902.1800000000021,30906,2394.4899999999998,7711.41,3616.8199999999988]
["VII. Exchange Rate and Reserves"]
["Forex Reserves (USD million)",362792.7,369954.7,372732,378763.5,386539.4]
["Re/ Dollar",68.78,64.84,64.22,64.59,64.739999999999995]
["Re/Euro",76.040000000000006,69.25,69.88,72.33,74]
["Forward Premia of USD  6-month",6.86,4.9000000000000004,5.61,4.71,5.19]
["VIII.  Public Borrowing and Inflation"]
["Govt. Market Borrowing-Gross (` crore) 2017-18",582000,582000,48000,108000,168000]
["Wholesale Price Index (2011-12=100)","185.5!","185.3!",113.2,112.8,112.7,"http://mospi.nic.in/"]
["Consumer Price Index (2012 =100)",130.6,130.9,131.1,131.4,132.1]
["IX.  Index of Industrial Production (y-o-y) percent (Base year 2011-12 = 100)"]
["General",120.5,131.5,117.6,124.3,"NA","http://mospi.nic.in/"]
["Mining",110.5,127.2,99,100.5,"NA","http://mospi.nic.in/"]
["Manufacturing",121.3,130.6,117.6,125.1,"NA","http://mospi.nic.in/"]
["Electricity",130.19999999999999,147.9,150.6,158.69999999999999,"NA","http://mospi.nic.in/"]
["X. External Sector Indicators (USD million)"]
["Exports ",24490.27,29232.05,24635.09,24014.62,23562.62,"commerce.nic.in"]
["Imports",33386.57,39669.22,37884.28,37856.339999999997,36522.480000000003,"commerce.nic.in"]
["Trade Balance",-8896.2999999999993,-10437.170000000002,-13249.19,-13841.72,-12959.860000000004,{"$error":"#VALUE!"},0,0,0]
["Notes: 1. * : Provisional Estimates; Data as per the new series released by MOSPI"]
["2. CPI Data ia being released on Base 2012=100 from January 2015 by MOSPI "]
["3. @ First Revised Estimates"]
["4. ! Base year is 2004-05 (2004-05=100)"]
["Source :  RBI, MOSPI,  Ministry of Commerce & Industry."]